Database Workbench version 2.3.1 released today!

[09-29-2003]
A new version for an already very complete tool - Database Workbench - has been released today. As a maintenance release to version 2.3.0, this version fixes some bugs found by users and has (beta) support for Microsoft SQL Server 7/MSDE 1.

Version 2.3.1

New features:

• Microsoft SQL Server 7 and Microsoft MSDE 1 support (beta)
• Microsoft SQL Server multi-instance support
• Updated documentation

• Added setting (DBNavigator) "Order by PK on Quick Browse"
• Added setting (Table Editor) "Order by PK on Data tab"

Bug fixes and small enhancements:

• Bugfix: Reporting: a "multi-report" now renumbers its pages
• Bugfix: DBNavigator: issue with description fixed and better handling of description changes
• Bugfix: Table & View Editor: fixed issue with showing previous name instead of new name on "New"
• Bugfix: Fixed an error with the BLOB Editor and cloned connections
• Bugfix: Fixed an error with creating new Users saying "Name templates not supported"
• Bugfix: Constraint Editors: Referred table listed twice in drop down box (FK constraints)
• Bugfix: Schema Migrator: Views cannot be migrated from an ADO/ODBC datasource
• Bugfix: DataPump: fixed an error with pumping from/to and loading/saving for delimited tables
• Bugfix: DataPump: fixed an error with loading/saving pump-files
• Bugfix: DataPump: fixed an error with MS SQL "bit" fields
• Bugfix: MSSQL: fixed an error with registering servers that aren't the default instance
• Bugfix: MSSQL: fixed an "Refresh List" error for Stored Functions in the DB Navigator
• Bugfix: MSSQL: fixed an error with some DEFAULT and RULE DDL parsing
• Bugfix: MSSQL: fixed a problem with exporting data -> columns weren't listed
• Bugfix: Firebird: UDF input parameters with a mechanism of "By Descriptor" weren't supported
• Bugfix: Firebird & InterBase: fixed an error with clearing edit boxes in the UDF editor
• Enhancement: MSSQL: Constraint editor for FK Constraint draws icons near selected referred constraint
• Enhancement: InterBase & Firebird: ability to specify datatype for COMPUTED BY fields

Version 2.3.0

New features:

• Microsoft SQL Server (2000) and Microsoft MSDE support!!
• Updated documentation

• Full tool support
• Full object editors support
• Administration/maintenance functionality via the Enterprise Manager & DB Navigator

• Shows total numbers of rows fetched on "end of dataset"
• Shows both the prepare and execution time of statements

• Allow duplicate objects to be editted before saving them to the database
• Data grids order by primary key columns by default
• XML export supported to Clipboard
• Printing options added - gives more control over printing output

• added "More DML" menu item to Table popup menu in DB Navigator with SQL shortcuts -> will open a SQL Editor, but not execute the statement
• added popup menus for Roles

Bug fixes and small enhancements:

• Bugfix: IB/Fb: fixed an error with GRANTing and REVOKEing rights to/from case-sensitives Roles
• Bugfix: IB/Fb: Restore Project options form didn't list Backup Projects
• Bugfix: IB/Fb: Fixed an error with double listing user names that don't exist at the server, but are a member of an existing role
• Bugfix: IB/Fb: Fixed an AV when using the ParamGrids On/Off button when not having a procedure selected in the Procedure Editor
• Bugfix: IB/Fb: Fixed an "View is in use" error when re-creating the view after using the Data tab
• Bugfix: IB/Fb: Fixed "No Changes Made" when only changing the Active flag in the Index Editor
• Bugfix: IB/Fb: Fixed Domain Editor showing length = 1 for new objects, while length = 0
• Bugfix: IB/Fb: Fixed an error with migrating Money, SmallMoney or BigInt domains
• Bugfix: Fb: fixed an error with registering a (local) server via the (local) protocol
• Bugfix: Removed an AV when using the SQL Editor result-grid popup menu without a resultset
• Bugfix: Fixed an error with the DataPump and ODBC sources without a PK
• Bugfix: Fixed the DBNavigator "doubleclick = browse" bug
• Bugfix: Fixed AV error when extracting table DDL from the List Extract Wizard for tables without a PK
• Bugfix: Fixed several minor GUI things
• Bugfix: Multi Export Data Wizard: fixed not showing relation name in progress dialog
• Enhancement: Misc GUI improvements including fixes for Large Fonts
• Enhancement: "Duplicate Object" dialog now uses Name Templates
• Enhancement: Several improvements to the Schema Migrator
• Enhancement: Running additional scripts via INPUT now raises an error when the file cannot be found
• Enhancement: Misc improvements to the SQL & Code Catalog