Database Workbench v2.7.5 released!

[07-19-2005]
Version 2.7.5 of Database Workbench is available for download now. It has several new features and enhancements and many fixes for bugs discovered in version 2.7 - which was the first release including Oracle support.

New Features

  • DataPump: ability to perform all transfers in a single transaction and avoid a COMMIT if errors occured
  • Right click code editor and select "Search Schema For..." will open the "Search Schema" window with the selected text or word under cursor
  • Ability to print SQL Editor grid and Data grid (Table/View Editor)
  • Oracle: syntax check for package and package body in Package Editor
  • Oracle, MSSQL: added syntax check to Trigger Editor
  • Oracle, MSSQL, MySQL: "rename" implemented for objects that support it (DB Navigator)
  • IB/Fb: ability to view connected databases and users for SuperServer

Enhancements

  • Added standard popupmenu to Trigger Editors
  • DBNavigator: warning if there are pending changes when doing a "refresh from db"
  • Several enhancements to the SQL/Script Editor
  • MySQL: ability to extract DDL for users
  • MSSQL: ability to extract DDL for "logins"
  • MSSQL: ability to extract DDL for multiple Linked Servers
  • MSSQL: "not null" attribute editable for existing columns
  • MSSQL: "identity" attribute editable for existing tables and new columns
  • Oracle: fetching of function/procedure parameters faster
  • Oracle: added "Extract DDL" buttons to User, Role, Tablespace and Rollback Segment Managers
  • Oracle: improved datatype mapping in Schema Migrator
  • Oracle: has a "keep alive" function on connections so that Oracle won't disconnect you after (default 15 minutes) a period of idle-time

Fixes

  • BLOB Editor: fixed error with not being able to delete data from BLOBs
  • CSV import failed parsing particular CSVs when "first row is header" was checked
  • SQL Catalog: "run" from the popup menu didn't work
  • DataPump AV fixed when closing DataPump after closing destination connection
  • When recompiling a stored procedure/function, it will reload the source from the database first to make sure it has the latest instead of a local cached version
  • duplicating a trigger and editting it before saving would default to standard timing etc...
  • Schema Migrator:
    • migrating "auto-inc" columns to a target that doesn't support them could fail
    • migrating constraints with owner-name-supporting source could fail
    • possible DDL extract errors fixed for certain combinations of migrating objects
    • fixed possible AV when migrating a constraint type, included with a table, that's not supported in the target datasource
  • InterBase and Firebird
    • fixed specific parse issue in the Procedure Debugger
    • fixed DECIMAL/NUMERIC without precision and/or scale in Procedure Debugger
    • fixed assigning floats to INTEGERs in Procedure Debugger/numerics with scale 0
    • fixed AV error after using Grant Manager and closing the connection
    • fixed an error with getting the check-constraint condition if the condition had a CHECK( part in it eg: EMAILCHECK(value)
    • debugger would not emulate string truncations for [FOR] SELECT ... INTO statements
  • IB: fixed possible thread deadlock in "Connections" monitor
  • MSSQL
    • fixed error with case sensitive database collations and fetching metadata
    • adding or viewing "linked servers" was broken
    • reserved words in view column names weren't delimited
    • fixed some view-sources not being parsed properly when loading from database resulting in mangled source in DBW
    • fixed some trigger-sources not being parsed properly when loading from database resulting in mangled source in DBW
    • fixed AV error when executing a procedure multiple times
    • fixed errr with executing a procedure that has no input parameters
    • sometimes, indices didn't properly refresh in the DB Navigator when saving them from the Index Editor
    • fixed a bug when dropping indices from the Index Editor when some other table had the same index name
  • Oracle:
    • fixed Alter Tablespace when adding new files
    • exporting "clobs" didn't get recognized as string data
    • couldn't connect to Oracle < 8.1.6 due to missing CASE SQL functionality
    • fetching parameters of encrypted functions/procedures failed
    • DBW handles encrypted procedures/functions more cracefully
    • creating a package body via the editor could fail
    • reported "% free" for Tablespaces was incorrect
    • completely empty tablespaces would be reported as 100% used
    • "Create/Alter View" without modifying it resulted in an "interface not supported" error
    • viewing Sequence dependencies in DB Navigator returned "interface not supported"
    • "dependencies" tab didn't show in Sequence Editor
    • unlimited tablespace quota wasn't used in DDL for new user
    • Package Editor retains "top line" position when switching between header/body
    • binary data now export to INSERT script with "HEXTORAW" function
  • Oracle, Schema Migrator:
    • migrating "image", "money", "smallmoney" to Oracle failed a datatype-mapping
    • migrating "datetime" to Oracle 8 failed a datatype-mapping
  • MySQL
    • additional registered databases and registration options weren't saved
    • fixed a Schema Migrator error when migrating FK-cascade rule that wasn't supported
    • binary data now exports as hex-string in INSERT script
    • fixed issue with NULL as default for string columns
    • fixed "Field 'Type' not found" when collecting table names for backup in newer MySQL versions
    • sometimes, indices didn't properly refresh in the DB Navigator when saving them from the Index Editor
    • fixed a bug when dropping indices from the Index Editor when some other table had the same index name