Database Workbench v2.5.0 released - complete changes list

[09-06-2004]
Below is the complete list of new features, enhancements and bugfixes for Database Workbench 2.5

New Features

Schema Compare

compare database objects
works cross-database-engine
generate an update-script (if possible)

DataPump: custom source SQL for datatransfer: allows you to concat, substr, do whatever you like to source data as long as it's returning a resultset
BLOB Editor:

Added PNG graphics support to the BLOB Editor
Added GIF graphics support to the BLOB Editor

Schema Migrator:

report filtering and printing
added Default and Rule objects (MSSQL) to migration process

CSV Import: added column-automap and buttons to auto-map/un-map all
Test Data Generator:

Added custom file support in "masked value"
Added (formatted) sequential number support in "masked value"
Added (formatted) random number support in "masked value"
Use a VIEW as the source for referential links
Added support for Bit/Boolean columns

Windows XP tested, supported and themed
Describe Companion:

Added "default" to columns
column description box to the bottom of the DC
ctrl+shift+D will attempt to lookup the table/view name from text under the cursor in any code-editor

Edit/drop/create Constraints, Indices and Triggers in the Table Editor
External Tools can be added to the Tools menu
Views are (DDL) extracted in the right order wrt VIEW dependencies
SQL Editor has a "auto commit" flag/indicator
Export data improvements
More and more complete documentation

InterBase Specific

"Trace Into" functionality in the Stored Procedure debugger
Tool tip evaluation of variables and parameters in the Stored Procedure debugger
Object template for "auto-inc" trigger
IB 6.5 and higher: statement cancelling in the SQL Editor

Firebird Specific

"Trace Into" functionality in the Stored Procedure debugger
Tool tip evaluation of variables and parameters in the Stored Procedure debugger
Object template for "auto-inc" trigger

Microsoft SQL Server Specific

Added sorting and grouped views to "Server Processes"
Added "Size" tab to "Database Properties" (EM) with pie-charts
Added "Linked Servers" management
Added "(System) Privileges" to the DB User, DB Group and DB Role Editors
Added "Create SUID Procedures" to the DB Navigator
SQL Server 6.5 supported (BETA)
Statement cancelling in the SQL Editor (for all but SELECT statements)
Fully "owner" aware

MySQL Specific

Added sorting and grouped views to "Server Processes"
Server Status/Variables grouped like in MySQL Administrator
Upgraded to the latest MySQL client, fully supports 4.1

Enhancements

Added %USER% and %COMPANY% to the macros for object templates, values can be entered at Preferences, General
Slightly re-arranged the DML items in the DB Nav, Computed columns removed from UPDATE and INSERT clauses. Added "UPDATE ... with parameters"
Schema Migrator:

automatic rename of (sub)objects already migrated for database engines that don't support global/local object names
Full Text Index recognized when migrating
Error reported when a constraint type isn't supported in the target datasource
FKs are extracted and created after all other objects
Defaults (for columns/domains) from MSSQL to has improved

SQL Editor:

added ctrl+Enter to execute statements
TOAD-like execution in the SQL Editor (by default)

BLOB Editor defaults to "As Text" for text-blobs and to "As Hex" for others
Added a Window bar to keep track of windows
Several GUI enhancements
DataPump: use "enter" to (dis)connect while the "Database" box is focused

InterBase Specific

Debugger/syntax check more version specific instead always the latest IB version
Faster execution when using Run/Run To Cursor

Firebird Specific

Debugger/syntax check more version specific instead always the latest Fb version
Faster execution when using Run/Run To Cursor
SAVEPOINT support

MS SQL Server Specific

Optionally shows object owner in DB Navigator (default ON)
More save error messages for invalid/incomplete objects
Removed SQL DMO dependencies
Removed "Service Control" items - didn't work properly
When registering a server, the drop down box also lists named instances.

MySQL Specific

SQL Editor allows to "execute" a procedure (CALL procname) without a "error creating cursor handle" error (MySQL 5)
Automatic detection of supported table-types for the Table Editor
Extract Indices before Constraints, some MySQL versions needs this for FKs
Defaults to a database-less connection, avoiding "mysql" database privilege problems, fixed some other privilege problems as well

Bugfixes

Removed several causes for Access Violations
"range check error" with auto-record-DDL ON and an existing log file
DBNavigator: object descriptions can no longer be editted and saved for database engines that don't support it in a lower version
Fixed several sync-errors
Error message during "connect" sometimes didn't show until you switched applications
"Field Specials" dialog help context number pointed to the wrong topic
Removed AV after doing a "Delete All Rows" which resulted in an exception
VisualQueryBuilder: fixed "copy to clipboard" button not working
VisualQueryBuilder: fixed flashing of SQL window when attempting to copy text
ExportData:

fixed a bug with exporting a single resultset to INSERT statements
XML Export: missing (N)CHAR datatype, BIGINT, both fixed
an exception could keep the export file locked
error in the Export dialog wrt the options frame (component "name" already exists) when going back and forth between pages

ODBC: fixed a transaction issue (mostly Access that complained about it)
Fixed CSV import with no "text delimiter"
Fixed CSV import error with not displaying drop downs in the grid
FKs/Unique Constraints didn't refresh columns in the DB Navigator
MSSQL/MySQL/Fb/IB: fixed a sync-issue with new tables and PKs
IB/Fb: Some obscure IBO related error with keeping a browse window open for a long time and doing some other stuff ;-)
IB/Fb: active/inactive refresh icon error for Active/Deactive Indices/Triggers
IB/Fb: fixed a plan-parser error when graphically displaying the query plan
IB/Fb: fixed AV error with Duplicate Column and Upper triggers
IB/Fb: fixed a small issue wrt Procedure Parameters and BLOB length
IB/Fb: setting a statement with an INT64 parameter failed
IB/Fb: changing a column raw datatype to a domain wasn't correctly "synced"
IB/Fb: fixed "rows fetched" <-> "all rows" inconsistency
IB/Fb: fixed a specific plan-parser error when graphically displaying the query plan
IB/Fb/MSSQL: table editor column description would sometimes be set for the wrong column
IB/Fb/MSSQL: deleting a renamed column resulted in "Column [newname] not found"
Schema Migrator:

MSSQL/MySQL/Fb: migrating FK constraints without tables would give an exception
MSSQL/MySQL/Fb/IB: migrating Unique/PK constraints without tables would give an exception
MSSQL/Fb/IB: migrating CHECK constraints without tables would give an exception

MySQL/MSSQL: fixed AV problem with displaying index column in certain cases
MySQL/MSSQL: removed possible AV error when disconnecting/refreshing from database
TDG: automatically sets "not null" columns to disallows NULLs, even though a previously saved project had "include nulls" set
TDG: referential link for (VAR)CHAR columns didn't work
DataPump:

fixed ADO connect strings not being saved to history
transferring INT64 from MySQL to "others" failed when retrieving values

EM: Improved error handling when not being able to connect to a server and fetch available-databases info -> this no longer aborts the process of displaying servers in the EM
Added "Roles" and "Users" to the database "Extract Metadata" wizard
Several small GUI related fixes

InterBase Specific

Debugger:

fixed parsing error with a specific BEGIN..END block
fixed ": not recommended outside SQL statement" warning
fixed an error with "gdscode" exception handling
fixed an error with NULL checking for parameters/variables
fixed a problem with EXTRACT
fixed a problem with ',' as the decimal separator
fixed an error with DATE/TIME variables and a "full-date is not a valid DATE or TIME"
increased precision of Float operations and removed a possible Integer Overflow error

"bigint" showed in views while "bigint" is only used internally
fixed several problems with Column Specials

Firebird Specific

Debugger:

fixed parsing error with a specific BEGIN..END block
fixed ": not recommended outside SQL statement" warning
fixed error with typos in variable datatypes
fixed an error with "gdscode" exception handling
fixed an error with NULL checking for parameters/variables
fixed a problem with EXTRACT
fixed a problem with ',' as the decimal separator
fixed an error with DATE/TIME variables and a "full-date is not a valid DATE or TIME"
increased precision of Float operations and removed a possible Integer Overflow error

fixed several problems with Column Specials

MS SQL Server Specific

Now lists multiple objects with the same name, but different owner
Restored server role descriptions
Removed error when creating new server-Login
Removed memory leak wrt PKs
Filter for "dt_" objects wasn't honored when doing a "Refresh List"
UDT with (var)char length (1) wasn't set on new UDT
New columns didn't bind a pre-defined DEFAULT
Not Null attribute for non-new columns could be set in GUI but was ignored, now, it can no longer be modified

MySQL Specific

Datapump: fixed a bug with regard to MySQL date/time/datetime data pumping
Removed "error creating cursor handle" when doing a DROP from the SQL Editor
"Export Multiple" used the " character as table delimiter, now it uses `
MySQL changes constraint names upon re-save, this is being reflected in the DB Navigator and Constraint Editor now
Removed memory leak wrt PKs
Fixed a MySQL script parsing error in certain cases
script didn't do "server output"