Version history for WinSQL

Version 17.0 Major Release

Version, Updated June 14, 2023
  • Quick Search - Details...
  • Enhanced Special Comments - Details...
  • Enhanced fix-length export
  • Ability to convert CHAR FOR BIT DATA to string when exporting from DB2
  • Enhanced error handling
  • Ability to include titles when exporting to CSV files
  • Ability to assign primary keys to views, which is useful when using the Update Wizard
  • Ability to specify a /clean as a command line argument, which ignores previously stored sessions

Version 16.0 Major Release

Version, Updated July 25, 2022
  • Duplicate Record Wizard has been added in Browse Data Screen.
  • Coping text to clipboard has been enhanced.
  • Enhancements made when exporting databags.
  • Oracle's ODBC driver has been updated to the latest version.
  • SQL file is automatically refreshed in memory based on last modified date.
  • Session restoration has been improved
  • TLS 1.2 can be enforced when communicating with an SMTP server.
  • Table names in catalog are sorted rather than displaying in their natural order.

Version 15.0 Major Release

Version, Updated October 29, 2021
  • Bug Fix: Copy/Paste does not work in result grid on certain computers
  • Bug Fix: Importing long data from Databag does not work
  • Bug Fix: Newly created table during import is not found if the table name contains an underscore or schema is blank
  • Bug Fix: Return parameter from stored procedure is not captured correctly
Version, Updated February 10, 2021
  • Shortcuts for Copy/Paste (CTRL+C/CTRL+V) works for catalog and history filter screen.
  • Default focus is changed to the DNS combobox in the connection window, provided user id and password fields are filled
  • Bug Fix: Ex classes were being overwritten during code generation.
  • Bug Fix: BIT data type was being exported as true/false rather than 1/0 for text export.
  • Bug Fix: SQL query for DELETEing record is incorrect when no PK exist in the table.
Version, Updated November 17, 2020
  • ODBC drivers are now available for both 32 as well as 64 bit WinSQL.
  • New 64bit drivers are now available for:
    • Amazon Redshift
    • Apache Cassandra
    • Apache Hive
    • Apache Spark
    • Google BigQuery
    • MongoDB
    • Salesforce
    • Snowflake
  • Ability to Export entire database to CSV or Pipe delimited format
  • Ability to schedule exports to CSV or Pipe delimited

Version 14.0 Major Release

Version, Updated January 15, 2020
  • Code Generation for multiple languages. Details...
  • Scheduled Offline Backups Details...
  • Enhanced command line support that works with auto-save sessions.
  • Display datatype with length for every column in the Update/Insert Wizard
  • Bug Fix: A blank WHERE clause is generated when a PK field is not included among the fields in the UPDATE wizard
  • Bug Fix: A SQL file cannot be opened from command line. For example: WinSQL c:\files\one.sql -uuserId -pPassword -dDSNName
  • Bug Fix: Update wizard occasionally uses incorrect table name if multiple tables exists with same name but different schema.
  • Bug Fix: E/R diagram does not draw itself until user clicks it
  • Bug Fix: Unable to save deleted local relationships
  • Bug Fix: When opening a workbook, the last file is not loaded.

Version 12.0 Major Release

Version, Updated March 07, 2019
  • Ability to Format SQL. Details...
  • Enhanced Code Templates. Details...
  • Cursor position is retained when switching between query pages
  • Special comment wn_PageTitle has been added allowing users to give a meaningful name to query pages. Details...
  • Bug Fix: wn_ShowColumnInfo was only displaying first 5 columns
  • Bug Fix: A question mark could not be used for query parameter. WinSQL was not escaping the character correctly
  • Bug Fix: When exporting to CSV format, double quote characters were not being escaped correctly

Version 11.0 Major Release

Version, Updated February 14, 2018
  • Enhanced catalog caching, which tremendously reduces the loading time of WinSQL
  • Lazy catalog fetching, allowing to catalog to load only when needed
  • New plugin for YellowBrick
  • Enhanced parametrized queries
  • Query results can be saved to HTML using a special comment
  • Ability to display errors in raw format
  • Integration with Windows Scheduler is improved
  • Enhanced intelli-tips. Writes a complete skeleton code for INSERT statements

Version 10.0 Major Release

Version, Updated June 28, 2017
  • Bug Fix: Stored procedure script cannot be displayed for MySQL
  • Bug Fix: WinSQL displays an error message when connection cannot be established when command line arguments are used, even if errors are redirected to an output file
  • Bug Fix: Browse button in the "Offline Backup" screen throws an exception
  • Bug Fix: WinSQL is unable to display results for queries containing more than 700 columns
Version, Updated May 04, 2016
  • Select All feature in result grid is now much faster.
  • SQL code can now be exported to Excel VBA
  • Work-around: IBM's Driver for Informix crashes when pulling SQL Keywords. If SkipKeywords.txt file is found in the DataFolder, WinSQL will skip pulling the keywords, avoiding the crash.
  • Bug Fix: WinSQL displays 4294967295 for modified records when the ODBC driver is unable to return exact count of rows affected by a DML query.
  • Bug Fix: Unable to run more than 1000 queries
  • Bug Fix: Last row in the grid was not included when printing grid results
Version, Updated February 01, 2016
  • Copy All is added to the main menu
  • WinSQL now accepts -d, -u and -p parameters by itself and opens a connection to the desired back-end when opening up
  • The top-left cell in the grid brings up the popup menu when clicked.
  • Recently accessed files are displayed in Explorer Window on the right
  • File Save dialog box defaults to .SQL extension
Version, Updated January 11, 2016
  • Two new extensions are introduced: .sql32 and .sql64
  • WinSQL now accepts -d, -u and -p parameters by itself and opens a connection to the desired back-end when opening up
  • Bug fix: The feature on was not working
  • Ability to double click the grid header to sort by that column
  • Ability to switch currently selected tab with keyboard shortcuts
Version, Updated December 23, 2015
  • Available in 32 as well as 64 bits
  • Auto-Save Sessions
  • 100% UNICODE compatible
  • Enhanced interface
  • Enhanced E/R diagrams

Version 9.0

Version, Updated August 4, 2011

Version 8.5

Version, Updated August 29, 2010

Version 8.0

Version, Updated September 28, 2009
  • 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.

Version, Updated August 31, 2009 Click here for more info...

Version 7.5

Version, Updated February 20, 2009
  • 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
Click here for more info...

Version 7.0

Version, Updated July 31, 2008
  • Ability to display results in form
  • Offline backup/restore
  • Text import wizard
  • File extention manager
  • History tab filter
Click here for more info...

Version 6.5

Version, Updated January 26, 2008
  • Ability to perform Data Diff between different type of databases.

Version, Updated January 15, 2008
  • 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
Click here for more info...

Version 6.0

Version, Updated August 29, 2007
  • FIX: Terminator parsing error when they appear in within a query.

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

Version, Updated July 16, 2007
  • FIX: Memory leak when exporting DataBag.

Version, Updated June 20, 2007
  • FIX: Ability to change resultset tab.

Version, Updated May 25, 2007
  • User comments for database objects
  • Extended BLOB/CLOB support
  • Data ToGo
  • Drag-n-drop data export
  • Quick Math
  • Treat unique index as primary key
Click here for more info...

Version 5.5

Version, Updated March 27, 2007
  • FIX: Displaying Binary data in Text gets truncated
  • Ability to disable automatic database change detection

Version, Updated January 10, 2007
  • FIX: Switching between query pages takes very long
  • FIX: Database change dialog is displayed after every query in some databases.

Version, Updated December 15, 2006
  • Task scheduler
  • Data lookup in intelli-tips
  • Virtual grid
  • FIX: Fast CSV and TAB delimited export
Click here for more info...

Version 5.0

Version, Updated May 5, 2006
  • 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

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

Version, Updated March 15, 2006
  • 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
Click here for more info...

Version 4.7

Version, Updated September 19, 2005
  • Intelli tips
  • Editable result sets
  • Grid Searching
  • Performance improvements
  • Databases switching
  • Tip of the day
  • Customized shortcuts
Click here for more info...

Version 4.6

Version, Updated March 15, 2005
  • Export to insert statements
  • SQL to code wizard
  • Extended copy
  • SQL Formatter
  • Enhanced editor
Click here for more info...

Version 4.5

Version, Updated July 14, 2004
  • 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

Version, Updated June 11, 2004
  • Data Diff wizard
  • Printing wizard
  • Enhanced DB Diff wizard
  • Plugin for MySQL
  • Enhanced multi-threading
  • Enhanced editor
  • Introduction of Developers edition
Click here for more info...

Version 4.1

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

Version, Updated May 21, 2003
  • 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.

Version, Updated May 5, 2003
  • Includes ODBC Drivers with WinSQL Professional and Lite

Version 4.0

Version 4.0.24, Updated April 8, 2003
  • FIX: Export template file not compatible with older versions

Version 4.0.22, Updated March 17, 2003
  • DNS less connections
  • Enhanced result grid
  • Queryset Workbook
  • Inline results
  • SQL code template
  • Enhanced SQL query wizard
  • Two-way database diff
Click here for more info...

Version 3.9

Version 3.9.22, Updated June 23, 2002
  • FIX: Catalog window does not display objects when "All Users" is selected

Version 3.9.21, Updated June 14, 2002
  • Catalog Tip
  • Stored Procedure Wizard

Version 3.8

Version 3.8.18, Updated Dec 04, 2001
  • 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

Version 3.8.16, Updated Oct 01, 2001
  • Database specific plugin
  • Browse data filter
  • Database Diff report

Version 3.7

Version 3.7.15, Updated July 20, 2001
  • 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.

Version 3.7.14, Updated July 2, 2001
  • 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.

Version 3.6

Version 3.6.13, Updated May 24, 2001
  • Insert/Update Wizard Added
  • Reverse Engineering. Generate CREATE TABLE statement
  • Allows users to disconnect and then reconnect without closing the window

Version 3.5

Version 3.5.11, Updated July 19, 2000
  • 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

Version 3.2

Version 3.2.8, Updated Dec. 5, 1999
  • 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.

Version 3.2.6, Updated Nov. 15, 1999
  • Result can be optionally displayed in multiple grid controls.
  • Enhance find/replace.
  • Code indent, undent.

Version 3.1

Version 3.1.6, Updated Oct 5, 1999

  • Fix: Value is not a valid floating point message displayed when viewing the catalog information. This problem only occurs for those clients where English is not the default language.
  • An option added for ignoring warning messages displayed during query execution. Useful if the backend database is FoxPro or DBase.

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

Version 3.0.4, Updated Aug 11, 1999

  • Fixed a memory leak problem in HTML wizard.
Version 3.0.1, Updated Aug 5, 1999
  • HTML publishing wizard.
  • SQL query wizard.

Version 2.0

Version 2.0, Updated July 20, 1998

  • Extended command line support was added.
  • Execution time for a query now shows in the status bar.
  • Query set now saves even the result set.
  • Error messages does not appear in a dialog box.
  • User can change the look and feel of the editor to suit their needs.

Version 1.5

Version 1.5, Updated Jan 5, 1998

  • When printing catalog in Windows 95, every page after the first prints in large fonts. This problem does not exist on Windows NT.
  • In the query editor a word is broken into two if there is an underscore in it. For example cust_count is considered two words and since "count" is a keyword, it gets highlighted.
  • Query editor takes very long to parse a long SQL statement for keywords.
  • Sometime when displaying Index information, garbage characters gets displayed for Index Pages.
  • A message opens up in the beginning that says "10/31/98" is not a valid date.
  • The query editor is significantly improved.
  • MS SQL Server only supports one database statement at a time. You can now optionally create a server side cursor. This will allow multiple statements to be opened at the same time. This will allow you to view the Catalog information while some query is executing.
  • Undo is now supported in query editor. Use CTRL-Z for to undo last change.



Social Media

Powered by