Database Workbench version 2.4.1 released today!

[12-03-2003]
A new version for an already very complete tool - Database Workbench - has been released today. This version brings you several new features and a list of bugfixes and smaller enhancements.

Version 2.4.1

New features:

• Updated documentation

• Added "Increasing Values" to Test Data Generator for Integer/Float columns
• Added "Random GUID" for (var)char columns
• Now handles UniqueIdentifier datatype for MS SQL (no fill/random/referential link)

• Added "As HTML" tab to the BLOB Editor

• IB/Fb/MSSQL: Drag/drop column(s) from the Navigator/Describe Companion to the Function/Procedure Editor to declare variables. Variables are named according a name template "Code Variable" in the Preferences.
• IB/Fb: Drag/drop column(s) from the Navigator/Describe Companion to the Procedure Editor parameter-grids to create input/output parameters

• IB/Fb/MSSQL: Drag/drop column(s) from the Navigator/Describe Companion to theTrigger Editor to declare variables. Variables are named according a name template "Code Variable" in the Preferences.

• MySQL: added "backup" and "backup project" functionality

• Added "Start Transaction" button to Table Editor/Data View

• Option to override current PK (absence of) name and generate a new name according to PK name template

Bug fixes and small enhancements:

• Enhancement: Added popup menu to SQL/Code Catalog items
• Enhancement: "Help" button in "Db Registration Options" dialog shows db engine specific help
• Enhancement: Added setting to show (default) procedure/function parameters after object name
• Enhancement: MSSQL: added GETDATE(), GETUTCDATE() and several others to the "default" drop down
• Enhancement: MySQL: Schema Migrator now maps (VAR)CHAR columns > 255 to TEXT
• Enhancement: IB/Fb/MSSQL: MySQL "TINYTEXT" now mapped to VARCHAR(255) when migrating
• Enhancement: Fb: "SUBSTRING" now recognized as a built in function in Procedure Syntax Check/Debugger
• Enhancement: IB: Fixes for Boolean assignments in Procedure Syntax Check/Debugger
• Enhancement: IB/Fb: Raise a warning when having a SUSPEND without output parameters in Procedure Syntax Check/Debugger
• Enhancement: Some minor enhancements
• Bugfix: Schema Migrator: (MySQL) converts MS SQL "getdate()" and other non-supported defaults (system functions) to an empty default
• Bugfix: Schema Migrator: fixed ADO PK constraints named "PrimaryKey" to be migrated as such
• Bugfix: DataPump: fixed showing wrong login/database information when selecting datasource type
• Bugfix: DataPump: fixed problems accessing ADO/ODBC Boolean/Bit columns
• Bugfix: MSSQL: fixed using SQL Server authentication for db connections, while it should use Windows authentication
• Bugfix: MSSQL: removed an error when closing a secondary SQL Editor and using the first one afterwards
• Bugfix: MSSQL: fixed Trigger DDL syntax for MSSQL 7/MSDE 1
• Bugfix: MSSQL/IB/Fb: fixed GRANT/REVOKE/DENY statements when using popup menus in Grant Manager
• Bugfix: IB/Fb: fixed an issue with the debugger/syntax check and BLOB variables
• Bugfix: Several "Abstract Error" exceptions fixed when using the Print button when printing is not supported
• Bugfix: Removed possible cause of AVs when using the Schema Migrator
• Bugfix: Several small bugfixes

Version 2.4.0

New features:

• Full MySQL (v4) support!!
• Updated documentation

• Added support for Firebird 1.5 BREAK/LEAVE

Bug fixes and small enhancements:

• Bugfix: Schema Migrator: Sequence/Generator values weren't migrated, despite the option for it
• Bugfix: Removed several memory leaks
• Bugfix: Removed "modified, but not saved" warning when saving SQL pages and closing the SQL Editor
• Bugfix: Fixed a problem with keeping connections alive, after disconnecting in the SQL Editor
• Bugfix: BLOB Editor: fixed a problem with tables that have multiple BLOB columns
• Bugfix: BLOB Editor: several problems fixed that could cause Access Violations
• Bugfix: Enterprise Manager: Selecting "Server Registration Properties" failed to work after initial connect-error when starting DBW
• Bugfix: Grant Manager: fixed possible AV error when applying Grant Templates
• Bugfix: Test Data Generator: fixed unable to fill fixed date/time value
• Bugfix: Test Data Generator: fixed a bug with deactivating indices/triggers for non InterBase/Firebird databases
• Bugfix: Test Data Generator: fixed a bug that made the fill settings invisible
• Bugfix: DataPump: Fixed AV error when datapumping widestring/unicode data
• Bugfix: DataPump: Fixed memleak with transferring NVARCHAR columns
• Bugfix: DataPump: Fixed a problem with Unicode/widestring/N(VAR)CHAR data
• Bugfix: DataPump: Fixed a problem with not loading "pmp" files correctly
• Bugfix: Metadata-printing problem with detail rows not appearing on sub-sequent pages (overflow)
• Bugfix: MSSQL: fixed a bug in the Index Editor not showing newly added columns after save
• Bugfix: MSSQL: fixed error with DataPump when pumping multiple tables
• Bugfix: MSSQL: fixed a bug with duplicating tables/views
• Bugfix: MSSQL: fixed a bug that causes AV errors sometimes
• Bugfix: IB/Fb: fixed a primary key naming bug that could result in the wrong PK being added to a table in the DB Navigator
• Bugfix: IB/Fb: Stored Procedure Debugger/Syntax Check didn't recognize the "FLOAT" datatype
• Bugfix: IB/Fb: fixed debugger AV when raising EConvertError on data assignment
• Bugfix: IB/Fb: fixed debugger error with looping IF..THEN - but without ELSE statement
• Bugfix: IB/Fb: fixed a small problem with displaying charset NONE for procedure parameters with no db wide characterset
• Bugfix: Fixed several other small problems
• Enhancement: Several GUI enhancements
• Enhancement: MSSQL: Speeded up export and DataPump starting speed
• Enhancement: IB/Fb: Stored Procedure DDL now extracted with 1 parameter/line
• Enhancement: IB/Fb: Stored Procedure Debugger enhancements
• Enhancement: Column name displayed in Table Editor, drop column dialog
• Enhancement: "Recompiled all procedures" and "Reset all generators" no longer visible in DB Navigator "Schema" popup menu for engines that don't support these objects
• Enhancement: Modified DataPump behaviour to automatically close connections on database/server/servertype change
• Enhancement: Non-supported constraint types removed in the Schema Migrator wizard
• Enhancement: Several improvements to the BLOB Editor