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