Many new features and updates to existing features have been added in Version 4.0. These changess are listed below
Now you do not need to create a DNS in the ODBC manager in order to connect to a database in WinSQL. Simply select "Specify connection string" check the box and specify a connection string. If you are not sure what string to provide, leave the connection string blank and WinSQL will prompt you for a DNS. Next time you try to connect the connection string will be filled for you.
Did you know that you DO NOT need to install Microsoft Access in order to use an MS Access database? You can create an .MDB file from ODBC Driver Manager and then use that file in WinSQL to issue SQL Queries. The default connection string is set to Microsoft MS Access. This makes connections to MS Access very easy.
Inline results (WinSQL Professional only)
Now results can be displayed in the same window as query tab. This is an optional feature and can be switched to a separate tab to mimic the functionality of earlier versions.
SQL Code Templates (WinSQL Professional only)
Code templates allows you to replace certain code snippets with actual queries. Using this features you can write queries like:
in Oracle to mimic the functionality exposed by SQL Plus. Note that the DESCRIBE command is not part of PL/SQL and is only available in SQL Plus.
Code templates are implemented through WinSQL Plugins and if you need to add any other template you will need to modify the Template XML file.
Click here for further details. Due the major enhancements in the Query Wizard, this feature is now only available in WinSQL Professional.
Two way DB Diff (WinSQL Professional only)
In the earlier versions users had to explicitly run the Database Diff wizard to compare both databases with each other. Now this is done by WinSQL. Both results are displayed side-by-side for better comparison.