InterBase Workbench version 1.3 released!

[07-01-2002]
The succes story continues - InterBase Workbench v1.3, the popular tool for InterBase and Firebird database engines, has been released. This version includes lots of new and exiting features including Datapump functionality, intelligent SUID procedure creation, Test Data Generator improvements and a BLOB Editor. Download your trial copy now or purchase licenses online. Don't fall behind, speed up your development, download InterBase Workbench!

Version 1.3

New features:

SUID Procedures
  • Easily create Select, Update, Insert and/or Delete Procedures
  • Use (optional) existing generator, or create a new one while creating the Insert Procedure
  • Names are generated from Name Templates, see Preferences, but can be adjusted
BLOB Editor
  • View and edit text and binary BLOBs.
  • View and edit as Text, Hex values, Image or OLE Object
  • Supported image types: Bitmap, Metafile, Icon, JPEG
Data Pump
  • Transfer data IB/FB - IB/FB
  • Transfer data IB/FB - ODBC
  • Transfer data IB/FB - ADO
  • Transfer data ODBC - ODBC
  • Transfer data ODBC - ADO
  • Transfer data ADO - ADO
  • Ability to save table/column mappings
  • Ability to order data, apply a custom WHERE clause on source data
  • Ability to use constant expressions for destination tables (generators, strings, numeric values)
  • Automatic (fuzzy) matching of column names
  • Runs in a seperate thread - you can continue working while transferring data
Test Data Generator
  • Ability to run in a seperate thread - you can continue working while generating data (remot connections only!)
  • Save/load Test Data Generator settings
  • Much more on screen progress indication and error reporting
Enterprise Manager
  • Database Statistics added - analyzes the DB statistics into a grid-overview
  • Database Sweep added
Database Navigator
  • Compute Index Selectivity or all Indices (Database Popup Menu)
  • Create intelligent SUID Procedures for Tables (right-click Popup Menu)
  • Reset generator from context menu
  • Added "Run Procedure" to Stored Procedure Popup Menu
Procedure Editor
  • For parameter datatype, you can select a domain and the datatype information will be copied (can be turned ON/OFF in the Preferences)
  • Added "Data" tab for selectable procedures
  • Added "Execute Procedure"
  • Ability to Run the procedure (select or execute)
  • Ability to save and load a procedure to/from a file for later editing
Trigger Editor
  • Ability to save and load a trigger to/from a file for later editing
Table Editor
  • Support for Column descriptions
SQL Editor
  • Statement History for keeping track of your SQL statements

Bug fixes and small enhancements:

  • Bugfix: Fixed not showing/readonly the object description in the Table Editor, Index Editor and Trigger Editor
  • Bugfix: Fixed (unneeded) extracting the DEFAULT and COLLATE clause in the Table Editor DDL tab
  • Bugfix: Fixed a metadata extract error from the Table Editor (no FKs, indices etc)
  • Bugfix: Fixed a 'list index out of bounds' when creating new triggers with the Triggers node expanded on a table/view
  • Bugfix: Fixed memory issues with exporting large result-sets
  • Bugfix: Fixed Role Editor not re-fetching any newly created users
  • Bugfix: ctrl+shirt+C didn't (un)comment in the Script Editor
  • Bugfix: Exceptions weren't included in database metadata extract
  • Bugfix: Bugfixes related to UNICODE and data-exporting
  • Bugfix: Some minor bugfixes
  • Enhancement: Changed Backup/Restore project fileformat to be valid XML
  • Enhancement: Small Grant Manager improvements & fixes