Archived news item "20050509.htm" - this will not display correctly.
Database Workbench v2.7.0 released!
We are proud to announce version 2.7.0 of Database Workbench, which includes the first version of your Oracle supporting module! Not all Oracle features are supported, but be assured that future versions will support more.
Besides Oracle support, there are also many bugfixes and small enhancements.
Oracle Database support:
support for schema objects:
Tested on Oracle 8, 9 and 10
Reports "print to file": PDF/RTF/HTML/Lotus/Quattro/BMP
MSSQL: "Syntax Check" in Stored Procedure and Stored Function Editors
MSSQL: Index Editor allows re-calculating index statistics
MSSQL: allow editting of PK name for new tables/tables without a PK
Shortcuts/context menu options to upper/lower/initcap case words or selected blocks
Grant Manager: added grid wide grant/revoke/reset to context popup menu in the grid
Added "Re-compile All Functions" and "Re-compile Function" to DB Navigator
Describe Companion lists Stored Functions and Procedures
ADO source supports migrating Foreign Keys if the driver supports it
ODBC source supports Foreign Key Constraints if the driver supports it
ODBC source supports Indices if the driver supports it
Minor GUI enhancements
User configurable code completion delay
accepts files that don't quote strings
added 1-on-1 automap when "first row is header" is unchecked
enhanced error reporting: faulty lines are saved to another file.
execute SET IDENTITY_INSERT ON for MS SQL tables
DataPump and TDG executes "set identity_insert ON" before transferring/generating data to MS SQL tables
DataPump lists source values on record transfer error
Right click "Schema" node in DB Navigator and select "Search in Schema" to search that schema
All Object Editors have their toolbars split up and positions saved
BLOB Editor uses less memory on (larger) BLOBs
New objects get added alphabetically in the DB Navigator
Grant Manager: can extract GRANT/REVOKE statements for current grantee only instead of always for all grantees
MSSQL: Added "Connect As" to Database popup menu
MSSQL: Ability to enter a different username/password combination for each available database
MySQL/Oracle: ability to register servers with the same hostname, but different additional attributes like "port"
IB/Fb: creating triggers at the same position will raise a warning
IB/Fb: improvements with name-warnings wrt special characters
Fb: support for Firebird 2.0 system defined external functions (cannot be editted or dropped)
IB/Fb/MSSQL/MySQL: Ability to edit hostname for registered servers
MySQL: added support for CSV and ARCHIVE table types
MySQL: ability to add PK/autoinc fields for existing tables
MySQL: ability to delete columns that are part of the PK
MSSQL: items didn't get added with owner name in the Describe Companion after the initial init of the DC
MSSQL: multi-directional indices didn't "update" its column direction for each column after changing and saving
MSSQL: Stored Procedure and Function editor didn't have the right popupmenu in the editor part
MSSQL: fixed some problems related to weird collations and SQL-query aliasses
MSSQL: fixed "sort buffer exceeded" problem with fetching tables/views for some databases
MSSQL: fixed DataPump error with transferring data into IMAGE column
MSSQL: doing "table fragmentation" and "rebuild index" could fail with message "no clustered index available" on the first attempt
MSSQL: Grant manager couldn't grant "Execute" or "Reference" on "User Defined Functions"
MSSQL: small error fixed for object locks not related to any database
MSSQL: GRANTs weren't extracted for User Defined Functions when doing a full schema DDL extract
MSSQL: statement recording for DDL didn't work properly from editors or SQL Editor
MSSQL: duplicating a table with a PK would result in the same PK-name being used, resulting in an error
MSSQL: DBW could lock up when having an uncommitted metadata change and doing a "refresh list" in the DB Navigator
MSSQL: removed error "[newtable] not found" on duplicating Table with PK and without "editting before saving"
MSSQL/MySQL: adding a PK in the Table Editor wouldn't display it in the Database Navigator
MSSQL/MySQL: Duplicating a table with a PK would result in an AV when closing the connection
IB/Fb/MSSQL: can no longer enter text in Procedure/Function editor when no procedure of function is selected
Fb: fixed bug when adding new indices and having "show table name" on in the DB Navigator
Fb: migrating/comparing an index to Firebird could fail with an AV
Fb: fixed [FOR] EXECUTE STATEMENT [var] warning "Value assigned to [var] never used" in debugger/syntax check.
Fb: Debugger/syntax check didn't support optional "VARIABLE" in DECLARE [VARIABLE] for Firebird 1.5 and up