Subject ANN: Database Workbench v2.4.1 released
Author Martijn Tonies
Ladies, gentlemen,

Upscene Productions is happy to announce the next
version of the popular database development tool:
Database Workbench 2.4.1 has been released today!

Download a trial at: http://www.upscene.com
Features and fixes: http://www.upscene.com/news/20031203.htm

Database Workbench supports:
- Borland InterBase ( v4.x - v7.x )
- Firebird ( v1.x )
- MS SQL Server/MSDE ( v7, 2000, MSDE 1 & 2 )
- MySQL 4

If you experience any problems with this new version, don't
hestitate and either go to the website and send a support email
or email directly to support@...

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
the
Trigger 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: Server log for MS SQL 7/MSDE 1 failed
Bugfix: MSSQL: "Space Usage" failed on non-US Locale settings
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: Error with CSV import and not importing all columns
Bugfix: Removed possible cause of AVs when using the Schema Migrator
Bugfix: Several small bugfixes




Thank you your support,

Martijn Tonies
Database Workbench - the database developer tool for professionals
Upscene Productions
http://www.upscene.com