Softpedia >Windows >Internet >Servers >Database Utils >SqlDbx Personal >  Changelog

SqlDbx Personal Changelog

What's new in SqlDbx Personal 6.17

Sep 12, 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

New in SqlDbx Personal 6.16 (Mar 1, 2021)

  • Fixes:
  • Fixed PostgreSQL scripting issue with procedures / functions

New in SqlDbx Personal 6.14 (Feb 1, 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

New in SqlDbx Personal 6.12 (Feb 1, 2021)

  • Fixes:
  • Fixed PostgreSQL scripting issues introduced in previous release
  • Improved import from Excel
  • Improved theme colors handling
  • Minor GUI changes

New in SqlDbx Personal 6.10 (Nov 29, 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

New in SqlDbx Personal 6.02 (Mar 4, 2019)

  • New and changed features:
  • Microsoft SQL Server 2017 support
  • GUI improvements
  • Updated Personal Edition

New in SqlDbx Personal 4.17 (Dec 8, 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

New in SqlDbx Personal 3.57 (May 7, 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

New in SqlDbx Personal 3.56 (Apr 17, 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

New in SqlDbx Personal 3.55 (Apr 17, 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

New in SqlDbx Personal 3.54 (Apr 17, 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

New in SqlDbx Personal 3.53 (Apr 17, 2012)

  • 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

New in SqlDbx Personal 3.52 (Apr 17, 2012)

  • 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

New in SqlDbx Personal 3.51 (Sep 26, 2011)

  • 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

New in SqlDbx Personal 3.50 (Jul 25, 2011)

  • New and changed features:
  • SqlDbx portable version
  • PostgreSQL support
  • Improved MySQL support
  • Scripting improvements (DB2)
  • Connection to uncataloged databases (DB2)
  • Better 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 MONEY columns display precision (Sybase ASE)
  • "Rerun Query" executes wrong query

New in SqlDbx Personal 3.48 (Jan 28, 2011)

  • 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

New in SqlDbx Personal 3.47 (Oct 18, 2010)

  • New and changed features:
  • Schema / Database filter
  • Script commands
  • Changed log options and log format
  • Added option to script USE (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 Pane 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

New in SqlDbx Personal 3.46 (Jul 19, 2010)

  • 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

New in SqlDbx Personal 3.45 (Jul 19, 2010)

  • 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

New in SqlDbx Personal 3.44 (Apr 5, 2010)

  • 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

New in SqlDbx Personal 3.43 (Mar 1, 2010)

  • 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

New in SqlDbx Personal 3.41 (Dec 7, 2009)

  • 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

New in SqlDbx Personal 3.40 (Oct 20, 2009)

  • Native x64 version of SqlDbx
  • Added multi column Results grid sort (Ctrl + double click)
  • Added support for Oracle XMLType column
  • 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
  • Fixed inconsistent DB2 connect behavior
  • Small improvements and enhancements in couple different areas

New in SqlDbx Personal 3.33 (Sep 14, 2009)

  • Enhancements and improvements

New in SqlDbx Personal 3.32 (Aug 17, 2009)

  • Added ability to select multiple objects in Object pane 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)
  • Improved generate SELECT/INSERT/UPDATE
  • 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

New in SqlDbx Personal 3.31 (Jun 15, 2009)

  • 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

New in SqlDbx Personal 3.30 (Apr 27, 2009)

  • 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

New in SqlDbx Personal 3.29 (Mar 1, 2009)

  • 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

New in SqlDbx Personal 3.28 (Feb 2, 2009)

  • Added support for Sybase SQL Anywhere and Sybase IQ
  • Added new feature: Quick filter in object pane
  • 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

New in SqlDbx Personal 3.27 (Dec 8, 2008)

  • 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

New in SqlDbx Personal 3.24.1 (Aug 4, 2008)

  • Fixed incorrect display of Oracle objects introduced in 3.24
  • Intellisense list now shows table columns in create table order
  • Fixed Shift Tab working inconsistently
  • Some other minor GUI changes

New in SqlDbx Personal 2.97 (Jul 31, 2007)

  • 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

New in SqlDbx Personal 2.96 (Jun 7, 2007)

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

New in SqlDbx Personal 2.92 (Apr 5, 2007)

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

New in SqlDbx Personal 2.90 (Mar 19, 2007)

  • 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 tables pane
  • Some other minor fixes

New in SqlDbx Personal 2.8 (May 3, 2006)

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