InterBase Workbench version 1.3.1 released!

[07-22-2002]
The succes story continues - InterBase Workbench v1.3.1, the popular tool for InterBase and Firebird database engines, has been released as a small maintenance and small feature update. 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.1

New features:

Data Pump
  • Views can be used as a source
  • Ability to use non-registered InterBase/Firebird databases
  • Improved loading/saving (including connection details)
Database Navigator
  • Ability to edit and save object descriptions
  • Added 'Reset All Generators'
  • Added 'Re-compile Procedure' and 'Re-compile All Procedures'
Procedure Editor
  • Added a simplified SQL Editor to test Execute Procedure results in the same transaction

Bug fixes and small enhancements:

  • Bugfix: Fixed Firebird RECREATE error
  • Bugfix: Search Database didn't search the View source code, double click a view wouldn't open the editor
  • Bugfix: Fixed several errors in the Table Editor causing Access Violations and other exceptions
  • Bugfix: Find Object in the Database Navigator caused Access Violations
  • Enhancement: Improved error-handling in the Data Pump
  • Enhancement: Auto-show Server Output window when running Scripts (See Preferences)
  • Enhancement: Improved speed of Test Data Generator by about 10-25% on (larger) char-columns and 10% in general

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