List:General Discussion« Previous MessageNext Message »
From:Martijn Tonies Date:May 9 2005 11:21am
Subject:ANN: Database Workbench 2.7.0 released
View as plain text  
Ladies, gentlemen,

Upscene Productions is happy to announce the next
version of the popular database development tool:
Database Workbench 2.7.0 has been released today!
Based on user feedback, there are numerous bugfixes,
new functionality and enhancements.

Download a trial at:
Features and fixes:

Database Workbench supports:
- Borland InterBase ( v4.x - v7.x )
- Firebird ( v1.x )
- MS SQL Server/MSDE ( v6.5, 7, 2000, MSDE 1 & 2 )
- MySQL 4, 4.1
- Oracle Database ( 8i, 9i, 10g )

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@stripped

New Features
- Oracle Database support
  - support for schema objects:
    - Tables
    - Views
    - Synonyms
    - Sequences
    - Stored Procedures
    - Stored Functions
    - Packages
    - Indices
    - Triggers
    - Constraints
  - 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
- Schema Migrator:
  - 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
- CSV Import:
  - 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
- MSSQL: fixed "sort buffer exceeded" problem with fetching tables/views for
- 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
         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
- Fb: Syntax check didn't recognize Firebird 1.5 GDSCODE/SQLCODE context
- Fb: "bigint" wasn't supported when migrating to Firebird 1.5
- Fb: Firebird 2.0 system defined external functions raised exceptions
- IB/Fb: fixed a rename-column error if you re-set the column name to it's
         original name
- IB/Fb: fixed a client-side exception happening if you changed a column
         from a varchar to non-varchar datatype
- IB/Fb: reserved words in columns are quoted (eg: "TYPE") when performing
         inserts/updates via data grids
- IB/Fb: single line comments (-- comment) wasn't valid for the Syntax Check
- IB/Fb: fixed bug in debugger with two SUSPENDs in the same loop
  returning the wrong values (current and next)
- IB/Fb: fixed register a database on different server than the
         newly registered server.
- IB/Fb: fixed an error in the Procedure debugger and large numerics
- MySQL: using the top left corner in the Grant Manager didn't grant
         all privileges
- MySQL: removed possible AV when searching for a constraint in the DB
         Navigator and not finding it
- MySQL: fetching metadata failed on MySQL 5 because of reported table
         type "memory" instead of "heap"
- MySQL: fixed an error with the PK DDL
- DataPump:
  - didn't show proper image for temp-tables in "destination" area
  - auto-map also mapped columns for computed destination columns
  - selecting a different ADO query syntax and then changing the connection
    type didn't set it to the normal syntax again
  - "index out of bounds" error when using ODBC as the target
- Schema Compare:
  - no script for Sequences/Generators was created
  - procedure parameters (IB/Fb) weren't modified and script collected
  - procedure/function parameter differences weren't properly detected
  - when both tables didn't have a PK, the SC would say "PK name different"
  - DDL compare: missed in-between-spaces as differences
- Schema Migration:
  - constraints would be migrated twice when selected and using the option
    "include table constraints"
  - Migrating from engines that don't support domains to engines that do
    support domains raised lots of warnings "domain ignored" while this
    doesn't apply
  - some ADO drivers don't support indices, this would result in an
- Fixed an error with adding data in grids, commit the transaction but
  the last inserted/changed row.
- Revised Export Data system: all exports are possible to folder, even
  for single table. All bugs in 2.6 fixed.
- Fixed problem with exporting missing "auto-inc" fields for XLS, DBF and
- DWX Import failed when rows couldn't be imported
- Assertion failure when creating new indices for duplicated tables
- "Users" were missing from the "Find Object" in the DB Navigator (for
  database engines that support schema-specific users)
- Exporting datetime/time to INSERTs would export "milliseconds" in the
- TDG: random length string did not honor lower boundary due to an error
- Fixed "Field xx not found" in BLOB Editor when switching tables while
  having the BLOB Editor open.
- Removed memory leak in all generic object editors

Thank you for your support,

Martijn Tonies
Database Workbench - the database developer tool for professionals
Upscene Productions

ANN: Database Workbench 2.7.0 releasedMartijn Tonies9 May