Release History
Version 6.17 (11 Sep, 2022)
Fixes
- Added support for Oracle 21c
- Improved diagnostic messages and error reporting
- Fixed couple issues with Intellisense
- Fixed rare crash when aggregating results
- Minor user interface changes
Version 6.16 (28 Feb, 2021)
Fixes
- Fixed PostgreSQL scripting issue with procedures / functions
Version 6.14 (30 Jan, 2021)
Fixes
- Fixed more PostgreSQL scripting issues
- Fixed retrieved rows counter not resetting correctly
- Fixed creation of default directories on first start
- Improved handling of Script variables. Added $undefine script command
Version 6.12 (10 Jan, 2021)
Fixes
- Fixed PostgreSQL scripting issues introduced in previous release
- Improved import from Excel
- Improved theme colors handling
- Minor GUI changes
Version 6.10 (30 Nov, 2020)
New and changed features
- Microsoft SQL Server 2019 support
- Oracle 19c support
- PostgreSQL 12 and 13 support
- Added option to execute query directly to file
- Improved compatibility with Wine
Fixes
- Script and substitution variables not handled correctly
- PostgreSQL multiple scripting issues
- Empty Object list for MySql version 8
- Force fixed font in some rare situations
- Vertica scripting improvements
- Invalid dates exported to Excel
- Replace template parameters is not working
- Incorrect export to csv file
Version 6.02 (3 Mar, 2019)
New and changed features
- Microsoft SQL Server 2017 support
- GUI improvements
- Release of updated Personal Version
Version 6.01 (24 Feb, 2019)
New and changed features
- MySQL 8.x support
- DB2 LUW 11.x support
- PostgreSQL 11.x support
Fixes
- Error loading Vertica ODBC driver
- Match begin end block sometimes does not work
- Timestamp column scripting in Sybase IQ and iAnywhere
- Error when using anonymous code blocks in PostgreSQL
- Column sorting is not working
- Application fails to run long scripts
- Editor sometimes freezes for 10 - 15 seconds
Version 6.00 (03 Feb, 2019)
New and changed features
- Vertica 9.x support
- UI Themes
Fixes
- Export to Excel of some numeric values
- Fixed multiple issues with search functionality
- Fixed multiple issues with MySQL / MariaDB support
- Force fixed font in editor
- Incorrect date format when exporting as SQL
- Missing field delimiter in CSV expor
- SpeedType file location can not be set
- Startup script is not executed
- Fixed issue with not being able to load some ODBC drivers
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 columns
Version 3.56 (17 Apr, 2012)
Fixes
- Missing CLUSTERED option for indexes (SQL Server)
- Incorrect columns scripted for indexes (Sybase ASE)
- Columns 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 color
- DBMS metadata scripting missing indexes and constraints (Oracle)
- IDENTITY columns 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 scrolling using mouse
- Main menu not displayed correctly in SqlDbx x64
- Arithmetic overflow in Databases admin query (Sybase)
- Intellisense drop down shows columns from unrelated table