News

Release History

Version 5.11 (20 Feb, 2017)

Fixes

  • CSV export
  • SQL Server scripting

Version 5.10 (04 Dec, 2016)

New and changed features

  • Apache Hive support
  • Separate settings for x86 and x64 drivers

Fixes

  • Error creating SpeedType file
  • Minor issues with Intellisense
  • Missing some shortcut keys

Version 5.01 (05 Oct, 2016)

Fixes

  • Fixed scripting for Oracle 12 which was broken in Version 5.0
  • Fixed issue with some keywords not recognized in specific locales

Version 5.00 (25 Sep, 2016)

New and changed features

  • SQL Server 2016 support
  • Estonian translation

Fixes

  • Directory in Scripting Dialog not saved
  • Table row count overflow
  • Oracle q'[ ]' string delimiters not handled correctly
  • Virtual columns not scripted (Oracle)
  • Intellisense fixes (Oracle)
  • SqlDbx editor becomes unresponsive in some rare instances

Version 4.17 (12 Jun, 2016)

New and changed features

  • This is the last version which will support Windows XP and Windows 2003

Fixes

  • Table aliases not handled correctly
  • GUI crashes in rare situation
  • Some minor improvements in multiple areas

Version 4.16 (01 May, 2016)

New and changed features

  • Improved performance of some internal catalog queries
  • Improved export to Excel

Fixes

  • Fixed scripting errors introduced in previous version

Version 4.15 (03 April, 2016)

New and changed features

  • Added partition scripting (Oracle)
  • Added option to set color for current highlight

Fixes

  • Incorrect scripting for some objects (Oracle, DB2)
  • Minor GUI and Editor fixes

Version 4.14 (06 March, 2016)

New and changed features

  • Added option to allow password encryption (Sybase ASE)
  • New option to execute current statement or block separated by empty lines
  • Added option to highlight all occurrences of current word in editor

Fixes

  • MySQL requires space for single line comment '--'
  • SQL Formatter is not working
  • Incorrect scripting of constraints with spaces (SQL Server)
  • Intellisense fixes
  • Sort of decimal and numeric column incorrect for some locales
  • Synonyms not expanding in Object view

Version 4.13 (07 February, 2016)

Fixes

  • Password dialog not showing for connections when password save option not selected
  • Some settings not saved correctly in portable mode
  • Always script column NULL and NOT NULL (Sybase, Microsoft SQL Server)
  • Formatted view source extracted instead of original (Sybase IQ)
  • Insert New Row option generates incorrect SQL statement
  • Broken shortcut keys in Results Grid
  • Minor GUI changes

Version 4.12 (25 December, 2015)

New and changed features

  • Added Excel export smart option for Timestamp columns
  • Updated catalog queries (Sybase IQ, Sybase ASA)
  • Chinese translation

Fixes

  • Object filters not saved correctly
  • Several internal queries do not free locks
  • Certain error message ignored and not displayed
  • Inconsistent and missing shortcuts
  • Generate Scripts includes incorrect objects (Sybase IQ, Sybase ASE)
  • Generate Scripts ignores some scripting options
  • Some schemas missing in Schema combo box (Sybase IQ, Sybase ASE)

Version 4.11 (4 October, 2015)

New and changed features

  • Added login options for IBM DB2 iSeries connection
  • Show number of rows in a group view in Result Grid
  • Preserve comment headers (SQL Server, Sybase ASE)
  • Minor scripting improvements (Oracle, Sybase IQ)
  • Improved error reporting (Sybase IQ, Sybase ASE)
  • Minimize locking in internal queries (SQL Server, Sybase ASE)
  • New Admin queries (Sybase IQ)

Fixes

  • Unhandled exception when using ODBC drivers
  • Rare x64 version crash
  • Drag / Drop from internal file browser
  • Unable to cancel scripting if database error
  • Incorrect copy / paste of date fields when modifying data in Result Grid
  • Scripting when using Oracle DBMS_METADATA package

Version 4.10 (2 August, 2015)

New and changed features

  • Enhanced Find Dialog (search all tabs, search global, search all in results)
  • Improved import from CSV
  • Better detection and load of ODBC drivers
  • Minor GUI tweaks

Fixes

  • Fixed SQL Formatter
  • Some settings not saved correctly in Portable Mode
  • Binary column display shows extra characters

Version 4.9.1 (15 July, 2015)

New and changed features

  • Updated and new Admin queries (PostgreSQL)
  • Added new script variable $(user)
  • Quick column look up in Result Gird (Ctrl + Shift + F)

Fixes

  • Intermittent crash when executing Named Regions
  • Rollback transaction on disconnect (IBM DB2)
  • Errors not handled correctly inside batch (SQL Server, Sybase ASE)
  • Error saving Unicode files
  • $define causes an error in Named Script Fragments (Oracle)
  • $define data types not handled correctly
  • Corrupted Recent Files menu
  • PRINT and RAISERROR output text corrupted in Unicode version (Sybase ASE)
  • Missing index icon in Object List

Version 4.8 (29 March, 2015)

New and changed features

  • Added option to reset connection after script execute (Sybase ASE)
  • New option to set transaction isolation level (IBM DB2)

Fixes

  • Connection fails when hostname:port/service specified (Oracle)
  • Unable set value to null when modifying table data
  • Fixed incorrect handling of Unicode files in ANSI version

Version 4.7 (27 January, 2015)

New and changed features

  • Option to specify PLAN_TABLE (Oracle)
  • Option to set cursor position after object scripting
  • Improved support for Sqlite, PostgreSQL

Fixes

  • Incomplete table scripting (ODBC)
  • Incorrect sort in Server Explorer
  • Server Explorer shows wrong objects (PostgreSQL)
  • Multiple database files displayed for Access ODBC sources
  • Editor cursor position is incorrect in some rare instances

Version 4.6 (28 December, 2014)

Fixes

  • Crash in Undo / Redo
  • Export to csv, html, xml missing second fractions for Date and Timestamp columns
  • DROP object does not work in some instances (SQL Server)
  • Changes to numeric or decimal values in Result Grid not updated correctly
  • Permissions scripting does not work or incorrect (IBM DB2)
  • Wrong sort order in Server Explorer (PostgreSQL)IBM DB2)
  • List of tables missing in Object View (SQLite)

Version 4.5 (2 November, 2014)

New and changed features

  • Additional columns (Rows, Time) in History view
  • User name removed from AppName
  • Minor GUI changes

Fixes

  • Crash when rearranging editor tabs
  • Incorrect scripting of objects names in some rare instances (Oracle)
  • Incomplete object scripting (Oracle)
  • Generate Insert not working when statement ends with ";" (Sql Server)
  • Fixed create type and create view (Oracle)
  • Console output missing (Unicode)
  • Search / Replace in Block Mode
  • Incorrect time zone conversion when option Convert TIMESTAMP_TZ to local time enabled (Oracle)
  • Mac end of line not handled correctly

Version 4.4.1 (14 September, 2014)

Fixes

  • Incorrect scripting of character column sizes for some character sets (Oracle)
  • Editor Undo / Redo disabled in some rare cases
  • Custom filters not restored correctly from session state
  • Procedure / function parameters not displayed (Oracle < 9.x)
  • Intellisense sometimes fails when object schema specified

Version 4.4 (1 September, 2014)

New and changed features

  • New options for cmd export=excel
  • Scripting improvements (SQL Server)
  • Intellisense improvements

Fixes

  • Copy from Visual Diff window
  • Missing characters and incorrect scripting in Unicode version
  • Incorrect scripting (Oracle)
  • Synonyms do not show in Intellisense (Oracle)
  • Potential crash when adding and deleting tabs

Version 4.3 (13 July, 2014)

New and changed features

  • Option to select text or graphical query plan
  • Remove unimplemented menus in Server Explorer

Fixes

  • Crash when option &qInclude Errors in Grid" is set
  • Potential crash when opening recent files
  • Search does not work in Messages tab
  • Setting Speedword completion keys has no effect
  • Relative directories in Portable mode
  • Only first statement executed in multi statement batch (Teradata)
  • Fixed some admin queries (Sybase ASE)
  • Wrong schema name in Visual Diff title
  • Minor GUI changes

Version 4.2 (08 June, 2014)

New and changed features

  • Full support for Teradata
  • Improved Informix support
  • Improved PostgreSQL support
  • Improved MySQL support
  • Server Explorer now supports MySQL, PostgreSQL and Informix
  • Added ability to connect using ODBC configured DSN's
  • Improved Intellisense
  • Separate configuration pages for all supported databases

Fixes

  • TIMESTAMP columns not detected correctly in some cases
  • BIGINT values truncated to INT
  • Potential crash when retrieving data
  • Incorrect case conversion in some rare cases
  • Relative directories not handled correctly
  • Backup files not overwritten anymore
  • Mac formatted files displayed incorrectly
  • System objects loaded from wrong database (SQL Server)

Version 4.1 (11 May, 2014)

New and changed features

  • Graphical Query Execution Plan (Oracle, Microsoft SQL Server, Sybase ASE, Sybase IQ, DB2 LUW)
  • Support for Sybase ASE 16.0

Fixes

  • Corrupted text returned in Unicode version
  • Error parsing nested function (Oracle)
  • Fails to load old Oracle Client version
  • Crash when expanding table columns (Oracle 8i)
  • Some warnings reported as errors (Sybase ASE)
  • Visual Compare Schema loads objects from wrong schema
  • Objects not sorted in Object Explorer
  • In some rare instances Grid Results shows extra outputs (DB2)

Version 4.0 (13 April, 2014)

New and changed features

  • Oracle 12c support
  • Named favorite script fragments
  • Group / subtotal result columns
  • New script commands to format results
  • Minor user interface updates

Fixes

  • x64 version crash when retrieving binary data
  • Text is missing when printing results
  • Index scripting incomplete (SQL Server)
  • Password not updated after change
  • Errors not displayed if password change failed
  • Toolbar buttons disappear or in wrong position
  • Unique index not used in Generate Update / Delete (Oracle)

Version 3.66 (16 Mar, 2014)

New and changed features

  • UTF-8 load / save support

Fixes

  • Unable to connect to Microsoft LocalDB default auto connect instance
  • Generate Scripts skips some objects in rare cases
  • Wrong or missing keyword colors in editor (Informix)
  • Unable to use alternative Oracle Home
  • Recent file list shows files in wrong order
  • Minor GUI changes and enhancements
  • Unable to select encoding when saving files
  • Server Explorer displays misleading error messages
  • Some East Asian fonts not rendered correctly

Version 3.65 (09 Feb, 2014)

New and changed features

  • Separate options page for Sybase IQ / Anywhere
  • Option to set auto or manual commit (Sybase IQ)
  • New script command: cmd diff
  • Norwegian translation

Fixes

  • Missing terminator when scripting views (Oracle)
  • Mark all words not working correctly
  • Wrong text inserted when using Copy / Paste block
  • Incorrect scripting of DEFAULT clause (Sybase IQ)
  • Table names missing in Intellisense (Sybase IQ)
  • Custom object filter does not work correctly when owner name present
  • $define variables not loaded for temp scripts

Version 3.64 (08 Dec, 2013)

New and changed features

  • Option to view Application Log
  • Change to how Script Variables work. DEFINE replaced with $DEFINE. $(var_name) syntax available in Oracle. &var_name depreciated
  • Shortcut to switch between connections. Ctrl + Shift + Page Down and Ctrl + Shift + Page Up

Fixes

  • Older SQL Server client connecting to new version of SQL Server (Text truncation)
  • Incorrect sorting in Unicode version
  • Issues with cmd result_current and cmd result_new
  • Incorrect options enabled in Quick Diff window
  • Missing owner in some instances (Oracle)

Version 3.63 (29 Sep, 2013)

New and changed features

  • Additional connection options (SQL Server)

Fixes

  • Single line comment requires carriage return (Teradata)
  • Field length is incorrect when Results in Text
  • SQL log fails if server name contains certain characters
  • Favorites not saved if server name contains certain characters
  • Incorrect drop statement for functions with default arguments (Informix)
  • Script object does not work from Favorites tab
  • In some cases scripted objects missing characters

Version 3.62 (1 Sep, 2013)

New and changed features

  • Outline SQL blocks. Shortcut to execute Shift + Enter
  • Support for collapsible regions --#region [Name] --#endregion [Name]
  • Display invalid objects in different color (Oracle)
  • Updated Admin queries (Oracle)
  • Italian translation
  • Minor GUI updates

Fixes

  • x64 version crash with result sets > 2GB
  • Execute/Script for overloaded functions (Oracle)
  • Focus not set correctly when add new result tab option checked
  • Incorrect fixed pitch font detection on Windows 7
  • Printer font not saved / set correctly
  • Backup file fails when using Save As...
  • Inconsistent source scripting for stored procedures (SQL Server)

Version 3.61 (12 May, 2013)

New and changed features

  • Sybase IQ 16 support
  • Option to see only difference in Visual Diff
  • Excel export options and Excel export templates
  • Option to include all columns in Generate INSERT
  • Export table data to current script window
  • Connect to Sybase ASE directly
  • Improved connection errors reporting
  • Option to change Editor and result grid tabs location

Fixes

  • Escape key does not close Visual Diff window
  • Errors connecting to SQL Server 7 and 2000
  • Incorrect generated DELETE or UPDATE when not all table constraints included in result set
  • Enable Table Edit option has no effect in Production mode
  • Registration dialog appears on every restart
  • Scripted NUMERIC columns do not include precision and scale (Sybase IQ)
  • Errors retrieving values from UNSIGNED INT and UNSIGNED BIGINT columns (ODBC drivers)

Version 3.60 (10 Mar, 2013)

New and changed features

  • New languages: Deutsche, French, Turkish
  • Removed restriction on modifying table unique constraint in Edit mode
  • Improved import from Excel
  • Option to display TIMESTAMP's with TIMEZONE in local time (Oracle)
  • Additional options in Generate Scripts
  • New licensing scheme

Fixes

  • Excel Export fails when string starts with '='
  • SqlDbx becomes unresponsive when script contains SQL*PLUS commands (Oracle)
  • Whole word replace sometimes does not work correctly
  • Current database not restored on restart (Sybase ASE)
  • Incomplete index scripting (Sybase IQ)
  • Long queries truncated in Data Diff window
  • Erroneous license violation dialog
  • File save fails in Unicode version
  • File can not be opened if it is already opened in another application

Version 3.59 (06 Jan, 2013)

New and changed features

  • Sybase IQ 15.4 support
  • Improved generate scripts feature
  • Ability to set HOSTNAME, APPNAME (Sybase ASE)
  • Enhanced limit returned rows feature
  • Improved usability

Fixes

  • Connection information not saved correctly (Sybase ASE/IQ)
  • Connect to default SERVICE_NAME does not work (Oracle)
  • Column total formatting does not match column format
  • Incorrect create index statement with INCLUDE (column) (DB2 LUW)
  • Error saving files when SqlDbx folder is read only
  • Painting issue in the object pane
  • Incorrect insert row for graphic and vargraphic columns (DB2)
  • Incorrect sorting of decimal values
  • Help not launching from Unicode and x64 version
  • Inconsistent handling of script commands

Version 3.58 (03 Sep, 2012)

New and changed features

  • Ability to directly define ODBC connections without creating DSN
  • Changes to Sybase admin queries

Fixes

  • Fix exception when retrieving long char columns using Access or Excel ODBC driver
  • Incorrect saving of login info (Sybase IQ, iAnywhere)
  • Error scripting physical table properties (Oracle)
  • Sybase IQ 12.4 scripting errors
  • Permissions scripting not working is some instances (SQL Server)
  • Resolved issue with ocs.cfg (Sybase ASE)

Version 3.57 (06 May, 2012)

New and changed features

  • Support for DB2 z/OS and LUW Version 10.x
  • Ability to run both x86 and x64 version from the same directory with drivers in Drivers and Drivers64 directories
  • Option to check for new version

Fixes

  • Script variables do not work with ODBC connections
  • Table checks not scripted correctly (Sybase ASE)
  • Table constraints not scripted correctly in some instances (Microsoft SQL Server 2005/2008)
  • Search in Object view does not work in x64 version
  • Fix for IBM CLI x64 driver reporting incorrect length for variable length culumns

Version 3.56 (17 Apr, 2012)

Fixes

  • Missing CLUSTERED option for indexes (SQL Server)
  • Incorrect culumns scripted for indexes (Sybase ASE)
  • Culumns of type TIME with value 00:00:00 displayed as blank

Version 3.55 (08 Apr, 2012)

New and changed features

  • Support for SQL Server 2012 and Azure
  • Improved permissions scripting (Sybase, SQL Server, DB2, Oracle)
  • Added option to executes SQL statements on connect

Fixes

  • Wrong driver loaded for ODBC connections
  • SqlDbx becomes unresponsive when searching in Object View
  • Generate INSERT does not work on filtered results
  • Non system tables owned by user informix not displayed (PostgreSQL)
  • "Unknown exception" error when exporting to Excel
  • Table properties not scripted for Sybase ASE 15.5

Version 3.54 (04 March, 2012)

New and changed features

  • Support for Sybase 15.7
  • Improved scripting (Sybase, SQL Server, DB2, Oracle)
  • New global variable (NEW_UUID)
  • Export as HTML
  • Copy as HTML, XML, CSV
  • Close Other Tabs option (Scripts, Results)
  • French and Russian translations

Fixes

  • Intermittent crash when selecting very long text data
  • No output for MESSAGE statement (Sybase IQ, iAnywhere)
  • Script truncated for very large tables
  • Last exported row to Excel has wrong formatting
  • Script variables do not use defined culor
  • DBMS metadata scripting missing indexes and constraints (Oracle)
  • IDENTITY culumn not scripted (Sybase ASE)
  • Long identifiers option not available for Sybase version < 15.x

Version 3.53(12 Feb, 12)

New and changed features

  • Improved error reporting (Oracle)
  • New Shortcut keys ALT+1, ALT+F3
  • Multi sheet export to Excel
  • Performance improvements (Excel export. Data compare)

Fixes

  • Database combo box empty (Sybase 11)
  • Error connecting using ODBC
  • Horizontal scrulling using mouse
  • Main menu not displayed correctly in SqlDbx x64
  • Arithmetic overflow in Databases admin query (Sybase)
  • Intellisense drop down shows culumns from unrelated table

Supported DBMS Systems

  • Oracle ® 8i - 12c
  • Microsoft ® SQL Server 6.5 - 2016
  • Microsoft ® Azure
  • IBM DB2 LUW ® 7.x - 10.x
  • IBM DB2 z/OS ® 7.x - 10.x
  • IBM DB2 iSeries ® 5.x - 7.x
  • Sybase ASE ® 10.x - 16.x
  • Sybase Anywhere ® 9.x - 12.x
  • Sybase IQ ® 12.5 - 16.x
  • MySQL ® 5.x
  • PostgreSQL ® 8.2.x - 9.x.x
  • Informix ® 9.x - 11.x
  • Teradata ® 12.x - 14.x
  • Kdb+ ®
  • Apache Hive
  • ODBC 3.0 compliant sources