Archived news item "20031203.htm" - this will not display correctly.
Database Workbench version 2.4.1 released today!
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.
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)
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
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.
MySQL: added "backup" and "backup project" functionality
Added "Start Transaction" button to Table Editor/Data View
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