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:

Overall
  • Microsoft SQL Server 7 and Microsoft MSDE 1 support (beta)
  • Microsoft SQL Server multi-instance support
  • Updated documentation
Preferences
  • 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:

Overall
  • Microsoft SQL Server (2000) and Microsoft MSDE support!!
  • Updated documentation
Microsoft SQL Server/Microsoft MSDE
  • Full tool support
  • Full object editors support
  • Administration/maintenance functionality via the Enterprise Manager & DB Navigator
SQL Editor
  • Shows total numbers of rows fetched on "end of dataset"
  • Shows both the prepare and execution time of statements
Tools
  • 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
Database Navigator
  • 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