VERSION HISTORY

 May 21, 2008 version # 3.01a

Improvements

#572

First private "alpha" release intended for beta testing by volunteered registered users.

 June 26, 2007 version # 2.15

Issues Addressed

#565

Fixed problem with backup and auto-saving functionality. If error occurs during save operation, 2.14 and earlier versions could corrupt both the backup and auto-save files.

#566

Fixed problem with copy/pasting of diagram text blocks.

#567

Fixed problem with paper format and orientation are not saved properly for paper formats other then Letter (default).

#568

Fixed problem in opening of diagrams, saved by previous versions of the Database Designer. DataType property was not correctly restored.

Improvements

#562

Added storing the order in which the relation items are created. This fixes the problem when the relationships rearranged manually in the diagram editor were resorted again after the diagram is reloaded.

#563

Added check for maximum length allowed for the identifiers (schema consistency testing).

#564

Added AllowHTMLFormatting option to the diagram text box. This allows to create a text box, which is not HTML formatted.

 April 27, 2007 version # 2.14

Issues Addressed

#536

Fixed minor problems in SQL Console window.

#537

Fixed problem with page settings not being restored correctly.

#538

Fixed minor problems in SQL import\reverse engineering.

#539

Fixed bug converting from previous versions of schema.

#540

Fixed several problems in Firebird 1 & 2 profiles (BLOB type, index creation).

#541

Fixed several minor printing problems.

#543

Fixed problem with domains not being imported during reverse engineering.

Improvements

#531

In schema consistency test added warning if object names matches certain masks, reserved for a particular database engine (e.g. RDB$, C_PK$, etc.).

#532

Added line scaling on diagram printing.

#533

Improved auto-layout of diagram tables.

#534

Adjusted Elevate DB profile to match changes introduced in 1.02 release (changed GENERATED to COMPUTED).

#535

Added log for all skipped statements and error during SQL import.

 February 14, 2007 version # 2.13

Issues Addressed

#508

Fixed problem in View & Stored Procedures Properties dialogs: unable to close the dialog when definition is wrong or is not terminated by the default term.

#509

Fixed several minor issues in diagram printing.

#510

Fixed bug: ‘size’ property is not enabled if field’s type is in lowercase (field type was being treated as case sensitive).

#511

Fixed several minor issues in Database Connection Properties dialog.

#512

Fixed several problems in MS Access database profile (msaccess.dbp file).

#513

Fixed several problems in Firebird database profile (firebird.dbp file).

#514

Fixed several problems in Nexus2 database adapter.

#515

Fixed bug: incorrect drawing of 0..1:1 relationship endpoints.

#516

Fixed bug: export schema dialog doesn’t confirm file overwriting.

#517

Fixed minor problems in SQL parser.

#518

Fixed problem affecting all database profiles: added views and stored procedures were not always correctly generated into SQL script.

#519

Fixed bug in ADO adapter: when reverse engineering views delimited names were not escaped with square brackets.

#520

Fixed bug in Connection Properties dialog. Connection parameters were not reset correctly when the adapter type is changed.

#521

Fixed bug: invalid unit name generated for Delphi Declarations when schema name contains spaces and other invalid characters.

#522

Fixed problem with index being recreated when only field name is changed, but not actually pointing to a different field. It is assumed that renaming field should also rename it (cascade) in indexes.

Improvements

#500

Added support for Firebird 2 database.

#501

Added support for Absolute Database by ComponentAce (http://www.componentace.com).

#502

Improved Schema Comparison Tool (see Comparing Schemes & Versions). Added command allowing to copy\update object definition into the current schema.

#503

Add log to reverse engineering of SQL scripts (see Reverse Engineering Database).

#504

SQL Console is no longer modal, allowing several consoles to be opened at the same time.

#505

SQL Console now allows script (batch) execution even if the database does not directly support it.

#506

Added query execution time to SQL Console.

#507

Added automated problem resolution for ‘invalid or empty index name’ problem (see Messages Window).

 December 18, 2006 version # 2.12

Issues Addressed

#482

Fixed bug in reverse engineering of MS Access database. Memo fields were converted to VARCHAR instead of LONGTEXT.

#483

Fixed bug with in MS Access database profile: GO was not generated after ALTER TABLE ADD PRIMARY KEY statement.

#484

Fixed bug: size property should be visible only for field types that support it (database engine specific).

Improvements

#485

Added warning when string field has zero size when testing database schema consistency.

#486

Added generation of default values for fields in MS Access SQL generation.

#487

Added support for autoincrement field type in MS Access SQL generation.

#488

Added FBPlus adapter for Firebird, Interbase and Yaffil, based on FIB Plus components by DevRace (http://www.devrace.com).

#489

Added diagram page arranging by dragging and dropping page tabs.

#490

Added reverse engineering from Information Schema for Mimer 9 database engine.

 October 9, 2006 version # 2.11

Issues Addressed

#468

Fixed Access Violation on testing database schema, when database profile is not assigned.

#469

Fixed bug in Relationship Properties dialog. When automatically creating fields the property SQLFieldType was not assigned.

#470

Fixed bug in search/replace dialog. When searching for views it was also returning stored procedures.

#471

Fixed bug in trigger definition parsing. Parser hanged indefinitely if it is unable to locate token 'ON'.

#472

Fixed bug with not saving Size property of a field definition object if it is equal to 0.

#473

Fixed problem with assigning duplicate names to unnamed indexes and constraints when importing from SQL script.

#474

Fixed problem with keeping file lock on previously edited schema (problem occurred after creating new schema).

#475

Fixed problem with parsing/skipping single word statements, like COMMIT.

#476

Fixed problem with printing multiple copies when collation is supported by printer driver.

#477

Fixed problems with help not being linked to some of the dialogs.

#478

Fixed problem with unnamed constraints not being assigned default names when importing from SQL script.

Improvements

#458

Added diagram export to BMP, PNG and HTML formats (see File | Export as Picture or Web page... command). HTML export generates image map for all tables and links.

#459

Added access to schema properties from Schema Import dialog.

#460

Added case sensitivity handling in schema consistency test.

#461

Added comprehensive support for Firebird 1.5 database. This includes: FB\IB Database Adapter, SQL generation, SQL import and Reverse Engineering.

#462

Added incremental import of SQL script into current database schema.

#463

Added option to automatically resolve some of consistency issues (see "Resolve this problem" context menu item in messages window).

#464

Added schema level option to enclose identifiers in double quotes or square brackets when generating SQL (i.e. enforce delimited identifiers).

#465

Added shortcuts for Create Version Checkpoint, SQL Console and Create or Update Database Structure.

#466

Added support for custom schema objects, which could be use to contain objects, like IB\FB Exceptions, file groups, etc.

#467

Improved Domain Properties dialog. The program now only require confirmation if any of the assigned domains have changed.

 August 24, 2006 version # 2.10

Issues Addressed

#452

Fixed bug in SQL generation for Nexus 1.

#453

Fixed bug in Page Properties dialog. Custom page format settings were wrongfully reset every time when the dialog is invoked.

Improvements

#447

Added Incremental Version Control option to Reverse Engineer dialog. This allows automatic creation of initial schema checkpoint for future synchronization of database schema.

#448

Added option to sort tables, views, procedures and other top level schema objects alphabetically. See Schema Tree View Window topic.

#449

Added ability to instantly compare schema with a physical database in Compare Schema dialog. Before now, a database must have been reverse engineered into a separate schema prior to comparison.

#450

Improved reverse engineering for Nexus 1. CtxNX1 adapter has been updated.

#451

Fixed Access Violation in Schema Comparison dialog.

 August 15, 2006 version # 2.09

Issues Addressed

#434

Fixed Access Violation when pasting deleted or renamed table onto a diagram.

#438

Fixed SQL generation & import for MS SQL Server 2000/2005 computed fields.

#439

Fixed bug in SQL generation of primary keys for MS SQL Server 2000/2005.

Improvements

#435

Added Add Related Tables operation (see diagram right-mouse menu). This allows quickly adding all tables related to the selected table to the diagram.

#437

Added Copy Table Definition operation (see Schema main menu, diagram right-mouse menu and Edit Table Definition dialog). This allow copying fields & indexes from other tables.

 July 24, 2006 version # 2.08

Issues Addressed

#428

Fixed error in Connection dialog when no adapters installed.

#429

Fixed A/V when deleting diagram pages.

#431

Fixed problem with disabling "Revert to Saved" command for new schemes.

Improvements

#426

Added support for MS Access, including reverse engineering via ADO.

#427

Improved handling of data times in MS SQL.

#430

Added help to Text Box Properties dialog.

 June 26, 2006 version # 2.07

Issues Addressed

#410

Fixed Stream Read Error occurred when reverse engineering databases on dual processor systems.

#411

Fixed bug in reverse engineering in MS SQL 2000.

#412

Fixed bug in reverse engineering in MS SQL 2005.

Improvements

#413

Improved data type conversion between different engines.

#414

Added relationship wizard to Toolbar and Tools menu.

#415

SQL Console and Update Database Structure commands added to Toolbar.

 June 21, 2006 version # 2.06

Issues Addressed

#404

Fixed bug exporting schema to PAS format;

Improvements

#402

Added extensive Search & Replace functionality;

#403

Added extensive support for MySQL 4 database;

#405

Added support for custom, database specific data types;

#406

Added automatic data type convertion when changing TargetDB - now supports extensible data type model;

#407

Added key properties highlighting in object inspector.

 May 31, 2006 version # 2.05

Issues Addressed

#401

Fixed A/V in schema consistency test, when validating a partially qualified relationship.

Improvements

#396

Improved reverse engineering for MS SQL 2000/2005.

#397

Added select statements support to SQL Console.

#398

Added command history to SQL Console.

#399

Added Relations Builder to import operations. This allows automatically detect and create relationships for the databases that do not support referential integrity.

#400

Added Auto Layout Diagram feature. This allows automatically lay out database tables and relationships on diagram page.

 May 9, 2006 version # 2.04

Improvements

#383

Improved handling of triggers, views and stored procedures.

#384

Imrpoved reverse engineering for Nexus 2.

#385

Imrpoved reverse engineering for DBISAM 4.

#386

Added code completion to all SQL editors.

#387

Added search to Script Editor.

#388

Added Create New Schema Wizard.

#389

Added Auto Save functionality.

#390

Improved Options dialog, added more options and default settings.

#391

Improved connectivity with schema component in IDE.

#392

Updated help file to reflect all latest changes.

 April 12, 2006 version # 2.03

Improvements

#361

Improved support for MS SQL Server 2000/2005

#362

Added support for Oracle and Nexus 2

#363

Improved schema consistency testing, added more warnings and errors related to foreign key constraints, type mismatches and more

#364

Greatly improved SQL import function.

#365

Reverse Engineering is coupled with import and improved to allow partial reverse engineering.

#366

Import functionality now allows to partially override schema objects, which is handled correctly by SQL generator.

#367

Added automatic handling of auto-incremental or identity fields when generating DML statements (e.g. when a table needs to be recreated preserving the data).

#368

Added Identity property to all field definition object.

#369

Add IDEF1X & UML notations to diagram.

#370

Fields display engine-specific data types and only allow to select data types, supported by the target database engine.

#371

Added popup dialogs for editing long script properties, like Check constraints and Description.

#372

SQL generation improved to allow deletion and smart recreation of all affected foreign key constraints. This is particularly important for engines, not supporting CASCADE deletion of tables, like MS SQL.

#373

Added custom connections parameters including UserName and Password for all database adapters.

#374

Added correct, engine specific, syntax highlighting everywhere where SQL text occurs.

#375

Improved adapters loading. Context Database Designer no longer loads adapters on startup, but only when they're required to establish database connection, which significantly improves startup time.

#376

Added Options dialog; Adapters page allows to add and remove database adapter libraries.

#377

Added data adapter for Nexus 2.

#378

Added Drop Database SQL generation (especially useful for databases, like MS SQL, that do not support CASCADE delete).

#379

Improved LUA compatibility.

#380

Updated context sensitive help.

 December 20, 2005 version # 2.02

Improvements

#340

Added extensive support for MS SQL Server 2000.

#341

Added table level CHECK CONSTRAINT(s).

#342

Added support for NATIONAL CHAR, VARCHAR and CLOB data types.

#343

Added generic database adapters, allowing to access more databases from the standalone application. This makes it easier to add support for more database engines in future.

#344

Relationships handling has been reworked and greatly improved, making it more stable and reliable. Now each relationship is defined as one singular object and not as two separate objects (one for each participating table) as it was before.

#345

SQL generation has been greatly improved, allowing for more extensive customization and providing support for more SQL features.

#346

SQL import has been greatly improved, allowing to correctly import triggers, views and stored procedures defined with different SQL dialects.

#347

Diagramming has been improved by adding (optional) IE notation for link drawing. Links avoid intersections with other links by drawing arcs (engineering standard).

#348

Interface better supports XP themes.

#349

Both regular and dockable windows stores their size and position, creating more user friendly environment.

#350

Improved user interface of editing tables, indexes and relations.

#351

Added advanced, database specific and user defined properties for more schema objects.

#352

Added context sensitive help file (partially under construction).

 October 31, 2005 version # 2.01

Improvements

#321

New, completely redesigned diagram editor with support for: undo/redo, copy/paste, multi-selection, metafile export, large page slicing for printing, enhanced drawing, interactive customized connectors and more.

#322

Schema & Diagram are stored in one file.

#323

Support for XML import/export.

#324

Completely redesigned and greatly improved schema editing dialogs, including support for custom user defined properties, syntax highlighting and more.

#325

Schema version control with checkpoints. Automatic SQL script generation for differences between version checkpoints.

#326

Importing schema from SQL scripts based on customizable engine profiles.

#327

Advanced schema comparison tool. Shows differences between any two schemas and/or any two versions of schemas. Automatically builds upgrade SQL script.

#328

SQL Console for direct manipulation with any registered database by executing SQL script and console commands.

#329

Direct access to databases from within Database Designer.

#330

Runs as a standalone application as well as IDE component editor. Interacts with Delphi IDE components via Ole Automation.