Change Log

Release History

Version 4.12 (25 Dec, 2015)

New and changed features

Added Excel export 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 (04 Oct, 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 (02 Aug, 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 (05 July, 2015)

New and changed features

Updated and new Admin queries (PostgreSQL)
Added new script variable $(user)

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

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)

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 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 "Include 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 (8 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 Apr, 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 autoconnect 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

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

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

Old 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
Editor and result grid option to change 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 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

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.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 column 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

Version 3.52(04 Dec, 11)

New and changed features

Support for DB2 iSeries version 7.x
Direct Oracle connection
Informix synonyms
Filter option to hide rows in Result Grid
New and updated Admin queries (Sybase, Sql Server, DB2)
Copy as text in Result Grid option
Display count in Search Database dialog

Fixes

XML type columns not displayed (Oracle)
Closing Results window exits SqlDbx
Unable to move Grid columns
Intellisense fix for table aliases
Single quote not escaped in Generate SELECT / DELETE / UPDATE
String quoting in SqlDbx Unicode
Do not display IN parameters when executing stored procedures (DB2)
TRUNCATE TABLE menu does not work (DB2)
Missing stored procedure properties (DB2 z/OS)
Do not display auxiliary tables (DB2)
Execute and Script Execute stored procedures fails (DB2 z/OS)
Incorrect scripting of DROP for materialized views (Oracle)
Incorrect scripting of GRANT for functions returning table

Version 3.51(25 Sep, 11)

New and changed features

Informix support (Pro Edition)
Improved support for PostgreSQL
New script commands (Pro Edition)
Simplified scripting for stored procedures execution (DB2, Oracle)
Import table data from CSV file (Pro Edition)
Option to disable / enable whole script execution
Option to display results in a new grid
Extended password security support (Sybase ASE)

Fixes

Truncation of long character columns (DB2, SQL Server, ODBC)
Unicode version uses too much memory
Intellisense fixes
Incorrect lower/upper keyword case in some instances
Unhandled exception in editor when moving line up / down
Incorrect Intellisense parameters for stored procedures (MySql)
References loaded for wrong schema
Export to CSV with no delimiters right trims VARCHAR columns

Version 3.50(24 Jul, 11)

New and changed features

SqlDbx portable version
Schema compare (Pro Edition)
PostgreSQL support
Improved MySQL support
Scripting improvements (DB2)
Connection to uncataloged databases (DB2)
Better connection error reporting

Fixes

Fixed issue with Oracle parser
Disable ODBC escape sequences
Disable not implemented menus and toolbar icons
Results in Grid / Text option not handled correctly
Blank DATE or TIME columns
Incorrect scale displayed for MONEY columns (Sybase ASE)
"Rerun Query" executes wrong query

Version 3.49(03 Apr, 11)

New and changed features

Svn integration (requires TortoiseSVN)
Quick Diff for Objects
Improved scripting (DB2)
Support for IN and INOUT stored procedure parameters (DB2)
Additional functions in Result Grid: AVG, COUNT
Option to set color of active line
Move current line up / down (CTRL+SHIFT+UP / CTRL+SHIFT+DOWN)

Fixes

Intellisense displays incorrect table columns for tables with the same name in different schemas (SQL Server)
Compilation errors not displayed (Oracle)
Handle invalid dates (Oracle)
"Scripting Options" dialog displayed multiple times
Multiple fixes for x64 version
Procedure source not shown correctly (Sybase IQ, iAnywhere)
Missing precision for DATETIME2 and TIME columns (SQL Server)
Exception when exiting with results windows open
Fixed incorrect display of UNIVARCHAR and UNICHAR columns (Sybase ASE)
Exception when pasting text from other applications
Incorrect system views used for some catalog queries (Oracle)

Version 3.48(27 Jan, 11)

New and changed features

Added Production and Non Production mode
Option to set restrictions for production mode (Options->Servers)
Added predefined variables $(TODAY), $(NOW), $(CURRENT_SCHEMA)
Script to Clipboard
Added option to truncate tables
Significantly improved Workspace / Session management
Minor UI changes

Fixes

Object list empty for case sensitive server installations (Microsoft Sql Server)
Generated permission statements missing separator (IBM DB2)
Generated SELECT / UPDATE / DELETE missing second fractions for some Date types
Some UI elements not updated correctly when switching between connections
Diff view displays identical lines as changed
Line numbers missing in Messages Tab
CLR functions not displayed in function list (Microsoft SQL Server)
Line numbers missing in Messages Tab
Erroneous scripting of permissions for triggers
SqlDbx window not visible when performing Alt+TAB

Version 3.47 (17 Oct, 10)

New and changed features

Schema / Database filter
Script commands
Changed log options and log format
Added option to script USE dbname (Sybase, MS SqlServer)
Editor option to untabify selection in Editor
Changed how new script tab names generated
Changed behavior of some shortcuts keys in Editor and Results Grid (HOME, END, PgUp, PgDown, Ctrl+D)
Some minor usability improvements

Fixes

Exception when loading session state from unavailable network share
Drop menu in Object View not working correctly when selecting multiple items
Unable to connect to Sybase ASE when certain database administration tasks running
Temp tables column not showing in Intellisense (Sybase, MS SqlServer)
Incorrect scripting of GRANT TO PUBLIC
Result Grid mode reset after each query
Editor is not responsive in certain situations

Version 3.46 (18 July, 10)

New and changed features

MySQL and Kdb+ support
Improved Intellisense
Added support for ALTER table statements
Scripting to new tab when SHIFT key is pressed
ODBC improvements (Indexes, primary / foreign keys)
Added ability to use ODBC drivers for some database systems without creating DSN entries
SQL Forms
Scripting to new tab when SHIFT key is pressed

Fixes

Long table constraints truncated (Sybase)
Incorrect number of affected rows by stored procedure (Sybase)
Inconsistent Editor behavior for some shortcut keys
Incorrect lower/upper keyword case in some instances
sp_procxmode not scripted for stored procedures (Sybase)
Search in Results not working for some locales
Couple small scripting errors
Exception when closing ODBC connections

Version 3.45 (09 May, 10)

New and changed features

Generate SELECT / INSERT / ... uses SQL formatter settings (SqlDbx Pro only)
Additional color options
Ability to "Mark" up to three different words
Export Results grid selection to CSV, XML
Additional date formats

Fixes

Table columns not sorted in Intellisense window
Table names missing owner (Sybase Anywhere / IQ)
Incorrect table scripting (IBM DB2 for z/OS)
Timeout connecting to DB2 on iSeries
x64 version access violation when pasting from clipboard
Spaces not handled correctly when using substitution variables

Version 3.44 (04 Apr, 10)

Fixes

Keyboard menu accelerators not working for languages other then English
Errors when performing operations on multiple selected objects in Object list
Unicode version does not connect to DB2 in Windows 7
Open multiple files sometimes does not open all files
No results when truncating text columns for Sybase
Incorrect behavior when selecting multiple objects in Object list
Incorrect scripting of constraint columns for Sql Server
Incorrect case for user types in Sybase and Sql Server
UNICODE files not loaded correctly

Version 3.43 (28 Feb, 10)

New and changed features

Support for multiple languages (Pro version only)
Updated system queries for DB2
Intellisense improvements
Enhanced Object list view
Info tips in Object list view
Two new scripting options
Floating windows layout saved / restored
Small changes and improvements

Fixes

Error connecting to Oracle 8.1.x
BEGIN / END blocks not matched correctly
Toolbar combo boxes not working on Windows 2000
Inconsistent menu items and shortcuts
Exception for ODBC connections
Reduced windows resources usage
Exception in Editor

Version 3.42 (11 Jan, 10)

New and changed features

SQL Log
Upper / Lower case scripting
Support for script / execute functions (Sybase Anywhere / IQ)
Enhanced scripting formatting
Improved handling of script variables
Keyboard shortcuts to switch focus between different windows (Ctrl+1, Ctrl+2, Ctrl+3)
Improved keyboard navigation
Multiple small improvements in Editor

Fixes

Incorrect cursor position after search
OUT parameters for SQL Server not scripted correctly
Crash during restoring saved session
Editor crashes when using bookmarks
Inconsistent keyboard shortcuts

Version 3.41 (06 Dec, 09)

New and changed features

Hide / Show lines in Editor
Template manager replaced by File browser
Initial support for Sybase IQ 15
Associate files with SqlDbx
Added date and time to SQL statement history
Added option to only generate update statement when editing table data
ANSI version can read UNICODE files
Small changes and improvements in different areas

Fixes

Intermittent x64 version crashes
Computed table columns were not scripted correctly for Sybase and SQL Server
Long passwords truncated
Oracle XMLType limited to 2K
Session state not restored correctly in some instances
File save dialog missing ANSI / UNICODE combo box on Windows 7
SqlDbx Unicode version not connecting to SQL Server on Windows 7

Version 3.40 (18 Oct, 09)

Native x64 version of SqlDbx
Added multi column Results grid sort (Ctrl + double click)
Added support for Oracle XMLType columns
Improved support for multiple Oracle Homes
Improved Table Export to file
Improved Insert New Row feature. Better handling of identity and timestamp columns
Fixed scripting of defaults and check constraints for Sybase and Microsoft SQL Server
Fixed painting issues on Windows 7
Small improvements and enhancements in couple different areas

Version 3.33 (13 Sep, 09)

Added ability to modify table data and generate UPDATE/INSERT for ODBC Connections
Improved support for Aliases / Synonyms for DB2 and Oracle
Improved Intellisense: display primary / foreign constraints for JOIN statement
Multiple improvements for DB2 scripting. Better support for DB2 iSeries
Displays execution time for each individual batch
Added data modify update statements to SQL History
Added option to toggle Editor column mode (ALT+C)
Added some missing menu items
Fixed Modify Table Data generating incorrect update statement
Fixed exception when generating UPDATE statement for Sybase
Fixed Cascade / Tile not working
Fixed Find All causes SqlDbx to hang
Fixed incorrect catalog /schema display for ODBC Connections
Fixed Intellisense missing some keywords and object names
Fixed SQL History not saved / restored correctly.
Small changes and improvements in different areas

Version 3.32 (17 Aug, 09)

Added ability to select multiple objects in Object View using SHIFT key.
Added ability to select multiple items in Intellisense popup window.
Added option to specify order of table columns in Intellisense popup window
Added option to enable number of returned rows by default
Added option to modify query results directly in Result Grid
Added ability to modify table data for tables with no unique constraints
Added new option to float and dock Object View, Edit and Result tabs
New Editor features. Go to Line (Ctrl+G) and Mark all occurrences of a word (Ctrl+M)
New Editor feature. Automatically highlight matching parenthesis
New Editor feature. Automatically highlight matching BEGIN/END IF/END IF, CASE/END, ... SQL blocks
Improved generate SELECT/INSERT/UPDATE
Added new option to generate SQL Plus compatible scripts for Oracle
Changed XML export format. Corrected date format
Fixed out of memory error when exporting table data to file
Fixed generation of execute script for Oracle package procedures
Fixed custom object filter not working
Fixed Shift key operation in Result Grid
Fixed exception when copying from Result Grid
Fixed exception when canceling Oracle queries
Fixed error when executing Oracle stored procedures with multiple output cursors
Fixed slow Intelliesense for Oracle and DB2
Fixed couple system catalog queries for DB2 z/OS

Version 3.31 (14 Jun, 09)

Custom object filters
Support for integrated BCP for Sql Server and Sybase
Added support for password expiration policies for Oracle, Sybase and Microsoft SQL Server
Added ability to change password
Added support for Run / Script Execute stored procedures with output parameters
Scripting improvements for DB2
Added option to script one object per file
Changed all DB2 catalog queries for to include WITH UR clause
Fixed exception when importing large Excel files
Fixed inconsistent behavior for CHAR columns between ANSI and UNICODE versions
Fixed intellisense for Oracle
Fixed incorrect painting on Vista and Server 2008
Improved compatibility with some ODBC drivers
Small changes and improvements in different areas

Version 3.30 (26 Apr, 09)

Added support for DB2 iSeries/AS400
Added option to reconnect with different credentials
Reload list of schemas / databases on reconnect
Fixed import from Excel ignoring values for some fields
Fixed issue with Speed Typing settings not being saved correctly
Server explorer enhancements
Fixed couple scripting errors for DB2 z/OS
Improved handling of script variables
Small changes and improvements in multiple areas

Version 3.29 (01 Mar, 09)

Added Microsoft and Sybase user types to Intellisense
Added "Insert New Data Row" option for tables
Added option to connect to Sybase IQ / Anywhere through Open Client or ODBC
Added shortcut keys to Show/Hide Results (F11) and Show/Hide Objects (Ctrl+F11)
Added option to output informational and error messages into Result Grid
Fixed access violation when opening workspace referencing non existent files
Fixed access violation for Oracle when entering SQL Plus commands
Fixed error displaying functions in Server Explorer for Sybase ASE 15.x
Fixed IDENTITY and COLLATION clause scripting for Microsoft SQL Server
Fixed Excel export for some locales
Fixed issue with Favorites not being saved in correct location
Objects with names containing "." characters were not handled correctly
ESC key was not closing some dialogs
Visual data compare was not correctly ignoring trailing right whitespaces
Improved usability and couple small improvements in different areas

Version 3.28 (06 Feb, 09)

Added support for Sybase SQL Anywhere and Sybase IQ
Added new feature: Quick filter in Object View
Added parameterized queries and substitution variables
Added ability to define completion keys for Intellisense
Added two new Excel export options: text, as displayed
Added "Edit Mode" for procedures / functions / packages
Added option to force "." as decimal separator
Fixed Intellisense not showing other Databases / Schemas
Fixed issue with Replace dialog hanging
Fixed scripting of user defined types for Sql Server and Sybase
Fixed incorrect number display for some locales
Intellisense enhancements
Scripting improvements
Usability improvements

Version 3.27 (07 Dec, 08)

Added SQL formatter / Beautifier (Professional version only)
Added supports for proportional and Asian fonts. Better IME support
Added ability to retrieve parent / child rows from Result Grid
Intellisense improvements
Improved SQL templates support
Improved compatibility with some ODBC drivers. Added batch separator (;) for ODBC sources
Oracle RAW and LONG RAW columns were not displayed correctly
Fixed speed typing not working correctly
Fixed error when changing server types in login dialog
Fixed issue with maximized window covering task bar
Fixed issue with not being able to edit data in Sybase tables

Version 3.26 (05 Oct, 08)

Changed how DECIMAL and NUMERIC columns handled.
Added back display of table row count. Now it's an option
Intellisense support for multiple temp tables in Sybase
Added ability to execute stored procedures and functions from Editor popup menu
New and changed Admin queries
ODBC connection improvements
Small GUI changes

Version 3.25 (07 Sep, 08)

Added option to not open connections when loading Session State
Added option to automatically disconnect from Server after user specified time period
Added option to commit or rollback when closing Oracle connections
Added support for SQL User Defined Functions for Sybase 15
Improved handling of temp tables for Sybase and Microsoft Sql Server
Couple improvements for ODBC connections
Fixed slow database change for Sybase ASE
Fixed issue with not releasing DB2 locks in some rare circumstances
Fixed issue with error lines not being indicated correctly for Sql Server
Fixed issue with number formats for some locales when generating INSERT/SELECT/UPDATE
Fixed issue with automatically committing changes when editing table data for Oracle when AUTO COMMIT is off
Enhancements and improvements in GUI, Editor and Results Grid

Version 3.24 (29 Jul, 08)

Some Results Grid shortcuts were not working
Fixed generate table script. Order of defaults, identity and constraints was wrong
Fixed identifiers not being quoted correctly sometime
Added diff options (case sensitive, ignore white space)
Added menus for Quick diff
Added ability to Edit / Delete Data Sources from Quick Connect
More color options (variable and command colors)
Intellisense list now shows table columns in create table order
SQL execution history now persist between restarts
Added option to copy column names with types and generate create table statement in Result Grid
Fixed Shift+Tab working inconsistently

Version 3.23 (09 Jun, 08)

Added support for Microsoft SQL Server 2008
Added support for Oracle 11g
Fixed error when using Oracle Client version prior to 8.1.xx
Fixed Intellisense for Oracle stored procedures broken in previous release
Enable multi line substitution values in Speed typing
Improved Visual Diff interface. Faster diff algorithm
New Quick Diff feature. Drag and drop text, script tab or result tab on a Quick Diff toolbar button to run diff between two items
Minor GUI changes

Version 3.22 (22 May, 08)

Fixed and added more options for multi selection in Object View
DBMS_OUTPUT was not working correctly in unicode version
Remember current script directory for each server connection
Fixed Replace Dialog hanging when doing replace all
Fixed couple issues with Intellisense for DB2. Missing procedures, showing of system views
BIGINT values now exported to Excel as text
Fixed incorrect number formatting
Some other minor changes and fixes

Version 3.21 (11 May, 08)

Object View now allows multiple selections. Enabled copying from Object View by using keyboard
Added ability to add results of every query to a new Result Tab (hold Shift key while executing query)
Added ability to toggle ON/OFF limit for number of query result rows
Fixed query results going to a wrong Result Grid
Keyboard shortcut menu key now works correctly
Fixed "Out of memory" error when selecting binary columns
Generate SELECT includes only columns visible in Result Grid
Long diagnostic messages not truncated anymore. Improved formatting
Fixed keyboard shortcuts conflicting with some keys on international keyboards
Some other minor changes and additions

Version 3.20 (27 Apr, 08)

Find, Replace and Object Properties dialogs are not modal anymore
Added ability to have multiple Result Tabs
New option to display column types in Result Grid
Locale aware number formatting and new number formatting options
Added option to script Oracle objects using DBMS_METADATA package
Server Explorer was not correctly displaying DB2 and Oracle procedures
Added missing Editor shortcuts for Ctrl+Backspace and Ctrl+Delete

Version 3.19 (06 Apr, 08)

Unicode version of SqlDbx Pro
Removed option to connect to Sql Server through DB-Library
Small fixes and changes

Version 3.18 (02 Mar, 08)

Fixed issue with intermittent locking of DB2 catalog views
Fixed incorrect scripting of DEFAULT values and GENERATED BY columns for DB2
Added ability to view BLOB's
Added display of return values for Sybase stored procedures
Fixed small scripting errors for Sql Server and Oracle
Fixed display of unsigned values for Sybase Version 15
Small GUI and Editor improvements

Version 3.17 ( 17 Feb, 08)

Added multi line cursor insert/delete/type to Script Editor. Added shortcut key to set block selection on (Alt + C)
Performance improvements in multiple areas (Export, Generate statements, Editor)
Changed how table import/export works
Small improvements and fixes in Editor, Excel export, Grid Results
Fixed access violation when retrieving Oracle NCLOB columns
Updated help file

Version 3.16 (05 Feb, 08)

Added extensive column (block) select/copy/cut/paste/drag/drop support to Script Editor
Changed behavior for option "Results in Script Window". Now output goes to separate window in a Results Tab
Added option to set capitalization for procedures/functions
BIGINT columns where not correctly exported to Excel
Some other small GUI changes

Version 3.15 (15 Jan, 08)

Added ability to directly execute Oracle package procedures and functions from Object View
Added two new items to Editor popup menu: Script Object to new Window and Sync Object View
Implemented explain plan for IBM DB2/UDB
Fixed issue with favorite objects not being refreshed
Couple scripting fixes for DB2 and Oracle
Small changes in different areas: Editor, Results Grid, Quick Connect
Added new shortcut key to switch between Editor and Results Grid (Ctrl + D)

Version 3.14 (06 Jan, 08)

New feature: Quick connect
Added more options to copy data from Results Grid and paste to Script Editor
Fixed copy / paste to Excel
Improved ODBC compatibility for some data sources
Intellisense extended to work with temporary tables in MS Sql Server and Sybase ASE
Added new command line options: -q, -r, -w

Version 3.13 (16 Dec, 07)

New features
   Sync Object View with Script Editor
   Added menu and shortcut keys for BEGIN, COMMIT and ROLLBACK TRANSACTION statements
   Added ability to switch AUTO COMMIT ON/OFF for DB2 and Oracle
IBM DB2/UDB improvements
   Added support for DB2 UDB version 9.x
   Improved support for zOS and DB2 V7
   SQL parser now better handles DDL an DML batches and recognizes --#SET DELIMITER command. See help for more details
   Admin queries added for versions 8.x and 9.x
   Intellisense recognizes DB2 Aliases
Improved IntelliSense
Editor now correctly applies color to multi line literal strings
Fixed issue with Sql Server and DB2 reporting an error when delete, update or insert did not affect any rows
Some minor GUI improvements and usability enhancements. Slight changes to menu structure
Fixed Results Grid print preview

Version 3.12 (15 Nov, 07)

New feature: Transpose data in Results Grid
Added configuration options for delimited file data exports
Intellisense was not working correctly for DELETE statement
Fixed handling of NULL values in Filter Grid Results
Do not truncate trailing blanks for VARCHAR columns when copying from Results Grid
Script variables values with spaces do not require quotes anymore

Version 3.11 (28 Oct, 07)

New feature: Script variables. See help for details
Significantly enhanced Speed Typing. Integrated with Intellisense. Now supports formal arguments
Option to parse scripts for syntax errors without execution implemented for Sybase ACE and Sql Server
Some other minor GUI enhancements and improvements

Version 3.10 (14 Oct, 07)

Intellisense and Auto Complete now work across databases, schemas and owners. Enable it in Options->Editor->Intellisense
Improved Intellisense. Now works in more cases
Added ability to execute procedures and functions directly from Object View.
Scripting for procedure and function execute now uses template parameters
Added command line options. SqlDbx Pro only. See help for details
Removed option to pre load packages for Intellisense for Oracle (not needed anymore). Fixed couple of bugs in Oracle SQL Parser
Fixed issue with mixed case object names and names with embedded spaces for Oracle and DB2
Generate INSERT/DELETE/SELECT now correctly handles string with embedded single quotes, binary columns and columns with NULL values
Editor performance significantly improved for very long lines
Fixed loading of incorrect system tables and views for SQL Server 2005
Added shortcut to select SQL block (Ctrl+B). Shortcut for selecting text block changed to Ctrl+Shift+B
Some other minor GUI enhancements and improvements

Version 3.00 (03 Sep, 07)

Added ability import / export table data to files and Excel
Improved support for international date formats in Generate SELECT/INSERT/UPDATE/DELETE
Fixed issue with output messages sometimes not displaying correctly for SQL Server
Fixed occasional freezing or termination of application while copying data from Result Grid
Export to Excel of date and numeric columns does not depends on formats selected in Options anymore
Some other minor GUI enhancements and improvements

Version 2.99 (21 Aug, 07)

Added ability to create connection aliases
Improved data diff
Enhanced template management
Fixed loading session state when using integrated security
Some other minor improvements

Version 2.98 (06 Aug, 07)

Fixed exception when accessing table properties in Sybase
Fixed capitalize keywords option being always on
Added option to manage file extensions

Version 2.97 (30 Jul, 07)

Fixed saving / restoring of session state if using multiple computers on a network
Fixed errors when creating Oracle triggers
Improved Search in database
Handle Oracle interval types
Better handling of timestamp columns for Oracle and DB2
Detect and reload files modified outside SqlDbx
Added ability to use wildcards in Find and Replace dialogs
Minor fixes and improvements. Some shortcut keys were not working. Missing keywords

Version 2.96 (03 Jun, 07)

Enhanced Find and Replace dialogs
Fixed couple small issues with Sybase and Oracle.

Version 2.95 (20 May, 07)

Now each script tab has it's own associated set of results
Redesigned results window.

Version 2.94 (12 May, 07)

Fixed incorrect display of BIGINT values
Significantly improved diff algorithm. Added ability to compare files
Improved support for DB2 7.1 on z/OS. Fixed incorrect scripting of FOREIGN KEY constraints for DB2
Fixed issue with expanding table columns for ODBC sources.
Minor GUI enhancements. Improved Intellisense keyboard interface

Version 2.93 (29 Apr, 07)

Added ability to save and restore user session state
Display number of rows affected by INSERT, UPDATE or DELETE statements
Intellisense improvements. Enhanced keyboard interface in results grid
Improved Visual diff
Fixed issue with inability to edit data in results grid for Sybase and SQL Server

Version 2.92 (05 Apr, 07)

Added new Favorite Objects feature
Improved support for Oracle and Microsoft servers
GUI improvements

Version 2.91 (29 Mar, 07)

Fixed date format bug introduced in previous release
Some other minor fixes

Version 2.90 (18 Mar, 07)

Microsoft SQL Server 2005 support
Added ability to apply filter in results grid
Added support for quoted Identifiers
Generate SELECT statement from results grid. Show table constraints in Object View
Some other minor fixes

Version 2.89 (04 Mar, 07)

Significantly improved support for ODBC sources
Added support for Sybase Version 15
New Auto Complete feature implemented. It can be configured in Editor Options
Multiple Oracle homes support

Version 2.88 (18 Feb, 07)

Intellisense changes
    System tables, views and procedures can be added to Intellisense. Options->Editor->Intellisense
    New auto suggest feature. Default shortcut key Ctrl+SPACE. Very basic at this time
    No popup lists and keyword capitalization inside comments
SQL History feature completely redone
New Quick search in script feature added
More DBA related queries
Fixed some menu and keyboard shortcuts
Some minor GUI changes.

Version 2.87 (07 Feb, 07)

Added handling for even more data types for SQL Server and DB2
Intellisense now works with procedures and functions in Oracle packages. You can add packages to be included in Intellisense
Fixed some accelerators keys not working in certain conditions
It's now possible to set values to NULL when editing table data
Some other minor enhancements and performance improvements in various areas

Version 2.86 (15 Jan, 07)

Added handling for more data types (SQL Server : BIGINT, BINARY, VARBINARY. DB2 : BINARY, VARBINARY)
Added option to select alternative background and text color for database connections
Copy to clipboard now works in Messages tab
Locale specific default date and time formats
Added ability to set column formats directly in Results Grid
Some other minor enhancements and performance improvements

Version 2.85 (11 Dec, 06)

Intellisense and UI improvements
Added option to print selection in results grid
Minor fixes and enhancements

Version 2.84 (29 Oct, 06)

Intellisense improvements. Table aliases recognized. DELETE and UPDATE statements supported. List of columns shows after WHERE and SET clauses
Display query plan and query statistics for Sybase, Oracle and SQL Server
Alternative window layout option added
Improved search in Object View of script editor
Fixed file saving to CSV and XML
Fixed connect / disconnect without closing script editor
Minor fixes and improvements in script editor

Version 2.83 (14 Aug, 06)

Allow to directly modify table data in result grid for tables with unique constraints
Option to limit number of returned rows. Option to see totals for numeric columns
Fixed scripting of Sybase triggers
Enable multiple selection in result grid. Copy and Generate statements use multiple selections.
Generate WHERE IN (...) expression from result grid
Minor improvements in editor, drag and drop, file handling

Version 2.82 (04 Jun, 06)

More accurate indication of compile error lines for all Servers
Fixed incorrect scripting of unique constraints for Sybase and Microsoft Servers
Fixed issue with object dependencies not being displayed correctly
Fixed incorrect parsing of CASE and OPEN PL/SQL statements for Oracle
Automatically display compile errors for Oracle

Version 2.81 (29 May, 06)

Improvements to DB2, Sybase and Oracle scripting
Added ability to dynamically connect / disconnect from Server

Version 2.80 (4 Apr, 06)

Support for code templates
Generate INSERT, UPDATE, DELETE from Results grid
Support for new data types in Oracle 10g
Improvements to IBM DB2 support

Version 2.70 (3 Feb, 06)

SQL Editor improvements.
Speed Typing
Initial support for Microsoft SQL Server 2005

Version 2.60 (16 Nov, 05)

Object scripting improvements
Discovery of available Servers

Version 2.50 (15 Jul, 05)

Initial support for IBM DB2
DBA style queries added

Version 2.00 (8 Jan, 05)

First public release of SqlDbx