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:

Overall
  • Updated documentation
Test Data Generator
  • 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)
BLOB Editor
  • Added "As HTML" tab to the BLOB Editor
Stored Procedure 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
Trigger Editor
  • 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.
Enterprise Manager
  • MySQL: added "backup" and "backup project" functionality
Table Editor
  • Added "Start Transaction" button to Table Editor/Data View
Schema Migrator
  • 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:

Overall
  • Full MySQL (v4) support!!
  • Updated documentation
Stored Procedure Debugger (IB/Fb)
  • 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