What's new in version 6.5

The following is a list of new features in WinSQL 6.5



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.

Integrated View Integrated View

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.

Enabling Catalog Cache 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. Cache Indicator


    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.
    • Data Diff template file (*.ddt)
    • Schema Diff template file (*.wdt) (
    • Export templates file (*.wet)

    Navigation

    Social Media

    Powered by 10MinutesWeb.com