• Scripting Wizard
• Drag-n-drag import from MS Excel
• Open results in MS Excel
• Parameterized executable

• Fix: Memory error when no plugin is selected and a query is run. Applicable only to WinSQL Lite
• Fix: Command line script generates an error when SQL comments are missing from the file header. Application only to WinSQL Professional.

• Exporting query results to a dynamic executibles
• Command line scripting
• Saving entire grid column to a folder
• Ability to skip lines during text import
• Enhanced text export wizard

• Ability export query results as executable files
• Printing reports based on query results
• Show/hide columns in result grids
• Customized email recipients for scheduled tasks
• Ability to copy relationship images to clipboard

• Ability to display results in form
• Offline backup/restore
• Text import wizard
• File extention manager
• History tab filter

• Ability to perform Data Diff between different type of databases.

• Integrated/Classic View
• Database catalog caching
• Ability to span Data Diff and Schema Diff reports to multiple files
• Use XML to store export, data diff and schema diff templates
• Drag-n-drop table names in query window
• Matching cursor highlight in query editor

• FIX: Terminator parsing error when they appear in within a query.

• Ability to switch Auto Commit mode after establishing connection
• FIX: Local comment parsing error when query terminator is found within comments.

• FIX: Memory leak when exporting DataBag.

• FIX: Ability to change resultset tab.

• User comments for database objects
• Extended BLOB/CLOB support
• Data ToGo
• Drag-n-drop data export
• Quick Math
• Treat unique index as primary key

• FIX: Displaying Binary data in Text gets truncated
• Ability to disable automatic database change detection

• FIX: Switching between query pages takes very long
• FIX: Database change dialog is displayed after every query in some databases.

• Task scheduler
• Data lookup in intelli-tips
• Virtual grid
• FIX: Fast CSV and TAB delimited export

• Improved Query Cancel option
• Option to close connection when a query is cancelled
• Auto-reconnect if a connection is lost
• FIX: Views/Procedure DDL truncation for larger scripts
• FIX: Cursor resets after save

• FIX: Memory violation occurs when using DDL script generator
• FIX: Informix Plugin fixed to handle larger scripts
• FIX: Copying entire grid runs very slow

• Relationship manager added in catalog tab
• Introduced local relationships
• History tab
• Drill-down results
• Export grid data to Text, CSV, MS Excel and MS Word
• Administrative tasks
• DDL scripting wizard
• Enhanced user interface

• Intelli tips
• Editable result sets
• Grid Searching
• Performance improvements
• Databases switching
• Tip of the day
• Customized shortcuts

• Export to insert statements
• SQL to code wizard
• Extended copy
• SQL Formatter
• Enhanced editor

• FIX: Some features in catalog tab does handle objects with embedded spaces
• FIX: Multiple result sets in MS SQL Server and Sybase are sometimes ignored

• Data Diff wizard
• Printing wizard
• Enhanced DB Diff wizard
• Plugin for MySQL
• Enhanced multi-threading
• Enhanced editor
• Introduction of Developers edition

• FIX: Search/replace bug fix
• FIX: Datatype problem in the plugin for Oracle
• FIX: Copying data from grid does not copy column headings

• FIX: Plugin for Informix did not display triggers correctly
• FIX: EditorSettings.cfg file is no longer placed in the Windows directory. It is placed where WinSQL.exe is.
• FIX: Minor bug fixes in the SQL Editor.

• Includes ODBC Drivers with WinSQL Professional and Lite

• FIX: Export template file not compatible with older versions

• DNS less connections
• Enhanced result grid
• Queryset Workbook
• Inline results
• SQL code template
• Enhanced SQL query wizard
• Two-way database diff

• FIX: Catalog window does not display objects when "All Users" is selected

• Catalog Tip
• Stored Procedure Wizard

• FIX: Escape clause in Update/Insert wizard
• FIX: Record Update/Insert wizard would not include SCHEMA name
• FIX: Test data generation wizard crashes if a dependent table does not have rows
• FIX: Test data generation wizard aborts if an out of range DECIMAL value is encountered

• Database specific plugin
• Browse data filter
• Database Diff report

• FIX: Memory allocation error occurs if a table is deleted and then added back to the E/R Diagram.
• FIX: PK/FK fields does not change when the relationship is deleted.
• FIX: Incorrect field name is selected in the parent table if the mouse is moved over other fields after the selection is made.
• FIX: HTML wizard changes all the data to lower case.

• Allows creation of Entity Relationship Diagrams, with printing and saving capabilities.
• Default value for query terminator is changed from a semi-colon to 'GO'.
• Users of WinSQL Lite will need to get a serial number from Synametrics.
• Serial number format for WinSQL Professional changed.
• Delete a record from Browse Table grid from the pop-up menu.
• Double click an existing record in the Browse Table grid to invoke UPDATE Wizard.
• Double click an blank row in the Browse Table grid to invoke INSERT Wizard.
• FIX: CTRL-V does not work in the Find/Replace window for pasting.

• Insert/Update Wizard Added
• Reverse Engineering. Generate CREATE TABLE statement
• Allows users to disconnect and then reconnect without closing the window

• Test data generation wizard added
• Data browsing added in catalog
• Catalog filter by object name added
• Local comment parsing introduced
• QuerySet can now be deleted as suppose to clearing the query window
• CTRL-INSERT and SHIFT-INSERT now work as clipboard shortcuts
• User can optionally select a full row or just one cell in the result grid
• FIX: Table not found error occurs when displaying a text file in the catalog window
• FIX: After displaying multiple resultset the grid tabs do not

• Optionally, auto commit can be turned OFF. Useful for Oracle and DB2.
• Displays a red indicator in the status bar if Auto Commit is OFF, green otherwise.
• If auto commit is OFF, users can right mouse click in the query window and either commit or rollback the transaction.
• Maximum limit per field in the resultset has been increased from 512 characters to 4096 characters in text control and 32767 characters in grid control.
• FIX: When a query page is changed, the resultset does not get updated with accordingly. This only occurs if the result is being displayed in grid.

• Result can be optionally displayed in multiple grid controls.
• Enhance find/replace.
• Code indent, undent.

Version 3.1.5, Updated Aug 28, 1999

• A wizard for New Table has been added that generates create table statements.
• Added enhanced support for Sybase and MS SQL Server including multiple resultset queries, PRINT and RAISEERROR statements. The ODBC driver version for Sybase must be at least 3.11 in order for the PRINT statements to work correctly.
• Fixed a problem with catalog viewing on DB2.
• Query terminator can now be up to 10 characters long. This is done to allow 'GO' as a terminator for Sybase and MS SQL Server.

Version 3.0.4, Updated Aug 11, 1999

• Fixed a memory leak problem in HTML wizard.

• HTML publishing wizard.
• SQL query wizard.