The most significant difference in version 6.5 is the ability to display catalog information right next to the query
Users can switch between Classic/Integrated view anytime they prefer. This feature is
available in the Professional Edition of WinSQL. In the case of WinSQL Lite and Developer, users
can only use the Classic View.
Optionally, users can cache objects in a remote database to a local file, allowing a quick retrieval of objects
next time you connect to the database.
Caching database catalogs is a very useful feature if you are connecting to a:
Large database with thousands of objects
A remote database with a slower network connection
Many features in WinSQL submit several SQL queries in the background to fetch
metadata information related to tables, views and procedures.
WinSQL saves this metadata to a local file when
caching is enabled. The prevents several round trips to the database next time
you connect to the same database.
The following information is saved in a local cache.
Datatype information for fields
Primary/Foreign key information
Stored procedure names
Stored procedure fields
|WinSQL displays the word "CACHE" in the status bar of WinSQL when a catalog
is loaded from the cache. The color of this word turns RED
if the cache is over 15 days old, reminding you to refresh the catalog as it might
have changed in the database.
Enhanced Data/Schema Diff
Version 6.5 allows Database Diff and Schema reports to span over multiple files.
Several WinSQL templates that used to be saved in binary format are now being saved in
XML. This allow users to easily modify these template files with any text editor. Following
templates are now being saved in XML.
- Data Diff template file (*.ddt)
- Schema Diff template file (*.wdt) (
- Export templates file (*.wet)