The most significant difference in version 6.5 is the ability to display catalog information right next to the query
tab.
Users can switch between Classic/Integrated view anytime they prefer. This feature is
available in Professional Edition of WinSQL. In case of WinSQL Lite and Developer, users
can only use the Classic View.
Database Caching
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 catalog is a very useful feature if you are connecting to a:
Large database with thousands of objects
A remote database with 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.
Following information is saved in a local cache.
Table names
Field names
Datatype information for fields
Primary/Foreign key information
View names
View fields
Stored procedure names
Stored procedure fields
WinSQL displays the word "CACHE" in the status bar of WinSQL when catalog
is loaded from 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.
XML Templates
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.
What's new in version 6.5
