Synametrics Technologies

Revolving around the core of technology

What's new in version 6.5

The following is a list of new features in WinSQL 6.5

Integrated/Classic View
Database Caching
Enhanced Data/Schema Diff
XML Templates

Download links:

Serial number (for WinSQL Lite)
Read Me (IMPORTANT)

Integrated/Classic View

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 the Professional Edition of WinSQL. In the 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 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.

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 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.
DBDiff enhancement

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.