Database Workbench version 2.4.2 released today!

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

Version 2.4.2

New features:

Overall
  • MySQL 4.1 Characterset/Collation support in Create Database, tables and columns
  • IB/Fb: editable COMPUTED BY columns in the Table Editor
  • SQL Editor: added support for '# ' as single line comment
  • CSV Export: more export options (text delimiters)
  • Export Data: multiple table INSERTs into a single file
  • SQL Insight: works with Aliasses (eg: EMPLOYEE E WHERE E.)
  • DataPump: added "auto-map", will map all tables and matching columns

Bug fixes and small enhancements:

  • Enhancement: Improved datatype reporting for ADO and ODBC
  • Enhancement: Improved "transaction capable" check in ODBC connectivity
  • Enhancement: Rewritten "catalog" stuff, including now a "Rename group" and unlimited levels of nesting
  • Enhancement: Multiple enhancements to the Visual Query Builder
  • Enhancement: DataPump: options are saved to .pmp file
  • Enhancement: Added more options to the Schema Migrator
  • Enhancement: MSSQL: system tables shown in the DBNavigator
  • Bugfix: TestDataGenerator: "till date" wasn't inclusive
  • Bugfix: TestData: fixed some "street" data without streetname
  • Bugfix: CSV Export: Boolean columns weren't written
  • Bugfix: Debugger: 'NOW' didn't work for date/time assignments
  • Bugfix: Debugger: fixed an error with a particular IF..THEN construct
  • Bugfix: BLOB Editor: HTML without a tag was displayed as plain text. DBW now automatically adds the tag
  • Bugfix: Several bugfixes to the Visual Query Builder
  • Bugfix: DBNav: "refresh" with a Table Editorr open would return an error (MS, MySQL)
  • Bugfix: Schema Migrator: error fixed when leaving "including constraints" checked when the source is ADO or ODBC
  • Bugfix: Schema Migrator: removed another cause for AVs
  • Bugfix: IB: removed (possible) AV when dropping PK from the DBNavigator
  • Bugfix: IB/Fb: db statistics was always done with SYSDBA instead of entered user
  • Bugfix: IB/Fb: made "generator" values Int64, avoiding overflows
  • Bugfix: IB/Fb: fixed the AutoInc Wizard when adding a column, didn't work
  • Bugfix: IB/Fb: fixed an error with simulated "alter view" that could result in view errors
  • Bugfix: Fb: descriptions on procedures were extracted with the wrong statement terminator.
  • Bugfix: MySQL: removed two AVs when migrating from ADO/ODBC to MySQL
  • Bugfix: MySQL: fixed delimited identifiers in columns: weren't delimited
  • Bugfix: MSSQL: removed a possible cause for AVs when closing connections
  • Bugfix: MSSQL: fixed a problem with long source in a trigger not being loaded properly
  • Bugfix: MSSQL: Table & View Editor weren't automatically "uppercasing" columns when required
  • Bugfix: MSSQL: fixed a problem with creating COMPUTED BY columns and "no datatype" message
  • Bugfix: MSSQL: (de)activating a trigger in the Trigger Editor could fail
  • Bugfix: MSSQL: using "refresh list" for triggers would add new triggers as inactive
  • Bugfix: MSSQL, MySQL: commented parameters not being taken out