Database Comparer VCL History

Version 3.2.47.10 (23 October 2007)

Implemented Features:

• TEXT to BLOB SUB_TYPE TEXT conversion was implemented;
• FB21: extracting of stored procedure parameters was improved (DOMAIN, TYPE OF DOMAIN).
• FB2: triggers support was added;
• FB2: UPDATE OR INSERT... MATCHING... RETURNING, TYPE OF <domain>, MERGE-statement;
• FB2: Common Table Expressions were implemented (WITH... SELECT...);

Fixed Bugs:

• TDBComparer: the problem with changing of database type was fixed;
• MSSQL: fields with UNIQUE-constraints were extracted incorrectly - fixed;
• The problem with parsing of "AS" statement was fixed;

Version 3.2.47.9 (24 September 2007)

Implemented Features:

• Delphi 2007 support was added.
• TDBCCustomConnection: TestConnectInfo() method was added.
• Custom OLE DB connection was added.
• MSSQL: stored procedure comparing improvements.
• MSSQL: Default constraints improvements.
• MSSQL: comparing of table-valued functions which return tables was improved.
• MSSQL: Update column position was added.
• MSSQL 2005 improvements: SCHEMA, TYPE, XML SCHEMA COLLECTION, XML INDEX.
• MSSQL 2005: extracting of Descriptions was improved.
• Sybase ASA: ALTER COLUMN, Primary key CLUSTERED.

Fixed Bugs:

• Oracle: "type of object" fix.
• IB/FB: errors in parsing of "STARTS WITH" and "ALTER EXCEPTION" statements - fixed.
• IB/FB: SET BLOBFILE does not work - fixed.
• IB/FB: CHAR/NCHAR (VARYING) datatype fix.
• MSSQL: OPENDATASOURCE, OPENROWSET, OPENQUERY fix.
• MSSQL: BEGIN TRY/CATCH fix.
• MSSQL: ALTER TABLE ENABLE/DISABLE TRIGGER fix.
• MSSQL: negative IDENTITY values.
• "DUMMY" was excluded from keyword list.
• ASA7: "Extract metadata from DB" fix.
• Memory leaks were fixed (TTrgData.Destroy, TCustomScriptExtract, TObjs).
• ADOConnection: "Timeout expired" error was fixed.

Version 3.2.47.2 (1 September 2006)

Implemented Features:

• MySQL: "Case sensitive identifiers" option added.

Fixed Bugs:

• dbcTableDataComparer.pas - Delphi5 compilation fix.
• Fix for packages: ComparerADOD7.dpk, ComparerMyDACD7.dpk, ComparerIBDACD7.dpk, remove using *.dcp libraries.
• DB2: Parsing fixes: CONNECT, CREATE TABLESPACE, CREATE INDEX, ALTER TABLE...ADD CONSTRAINT.
• Yaffil: Fix for parse function PAD (...FOR...)

Version 3.2.47.0 (20 July 2006)

Implemented Features:

• IB DAC support was implemented.
• TableDataComparer: Logic related to deleting of records improved.
• News icons added.

Fixed Bugs:

• IB/FB: BLOB SUBTYPE TEXT - charset fix.
• TableDataComparer: Processing of fields of BIGINT type fixed.
• MSSQL: Case sensitive databases fix.
• IB/FB: Grants for views fix.

Version 3.1.45.0 (8 June 2006)

Implemented Features:

Oracle:

• Processing fields of CLOB datatype improved in TableDataComparer.
• GLOBAL TEMPORARY TABLEs support added.

MSSQL:

• Parsing of SELECT TOP <expression> * FROM <table> expressions improved.

ASA:

• Parsing of EVENT statements improved.

ASE:

• Processing of script header improved, comparison of database options added.

Fixed Bugs:

Oracle:

• Parsing fields of VARCHAR2( size ) datatype fixed (size was not extracted properly).

MSSQL:

• Parsing of CREATE DATABASE statement fixed.
• Parsing of IDENTITY (data_type [ , seed , increment ] ) AS column_name fixed.
• Parsing of procedure calls without parameters fixed.
• Table-valued functions being not extracted from databases and update of table-values functions fixed.

ASA:

• Parsing of GRANT statement fixed.
• Parsing of CREATE DOMAIN statement fixed.
• Parsing of GO-terminator fixed (some statements stared with GO... were interpreted as terminator).
• For v 8.x extracting of metadata fixed (related to error "Table SYSCONSTRAINT not found").

ASE:

• Bug related to unknown field "xtype" error in TableDataComparer fixed.

IB/FB:

• Parsing of PLAN options fixed.
• Parsing of ALL keyword as and argument inside aggregate function fixed.
• Parsing of ALTER TRIGGER statement fixed. (ALTER TRIGGER <trigger-name> {ACTIVE/INACTIVE}).
• Parsing of string datatypes inside UDF parameters fixed (size was not extracted properly).
• Interbase v 5.x error "Can't find procedure isc_service_attach in gds32.dll" fixed.

Version 3.1.43.0 (21 March 2006)

Implemented Features:

• Extract and compare Metadata for Sybase ASE, Postgre SQL, IBM DB2 implemented.
• Oracle: extracting and processing of TYPE's and PACKAGE's added.
• MSSQL: MSSQL 2005 support added.
• MSSQL, Sybase ASE: Full-text parsing implemented allowing to extract metadata from IF conditions and parameters of sp_executesql.
• MySQL: Support for GIS (geographic information system) datatypes added.
• MySQL: Tables creation algorithm improved (constraints, keys).
• TableDataComparer - property IngnoreComputedFields added.
• Sybase ASE: Support of roles, logins, users and rights added.
• Various improvements related to work with Sybase ASE.
• IB/FB: Field datatypes conversion improved (using update of system 
  tables), controlled by AllowDatatypeConversion option.
• Comparing of scripts and databases for Sybase ASE (initial 
  implementation).
• MSSQL: Extraction of Defaults from database for MSSQL2000/2005 was 
  improved.

Fixed Bugs:

• IB/FB: Bug related to creating/deleting of roles when comparing databases - fixed.
• MSSQL: Float datatype fix.
• MSSQL: Parsing of trigger's headers fixed: {FOR / AFTER / INSTEAD OF}, 
  [WITH APPEND], [NOT FOR REPLICATION].
• TableDataComparer: IB/FB Dialect 3 table names fix.
• Oracle: Execute script fix, Extract packages, types from database.
• TableDataComparer: Output format fix for float values.
• PostgreSQL: v.8.0 fix (relation "pg_catalog.pg_authid" not found).
• IB/FB: VARCHAR(1) fix.
• IB/FB: Missing "AS" when parsing triggers - fixed.
• MSSQL: Parsing of GRANT statement fixed.
• MySQL: Parsing of Unique key fixed (length of the key was ignored).
• MySQL: Engine MEMORY/HEAP fixed (identified as separate statements).
• IB/FB: Relations were extracted only for triggers - fixed.
• IB/FB: Identifiers starting with "_" was not quoted.
• IB/FB: UDF calls without return params (type RDB$SET_CONTEXT) - fixed.
• IB/FB: Parsing of CREATE TRIGGER... without [POSITION n] fixed.

Version 3.0.41.0 (10 January 2006)

Implemented Features:

• A new component for comparing and synchronizing table data was added.
• The following SQL servers support was added: MS SQL, Oracle, MySQL, Sybase.
• Now the Database Comparer VCL can be independently compiled with any version of supported database engines.
• The following database engines are supported: ADO, BDE, DBX, IBX, FIB, IBO, ZEOS, MyDAC and ODAC.
• Now the SQLExec component can be used independently from DBComparer component for executing any SQL scripts.
• TableDataComparer: Sybase support was added.
• Sybase: Extract and compare PUBLICATIONs.
• Sybase(ASA): Extract metadata from DB, compare DB-structures, update DB-structure, execute external script.
• IB/FB: Option "Ignore IBE$... objects" added (ignore objects created by IBExpert).
• Dependencies of grants with the objects are added.
• MSSQL2000 keywords are added. Quoting of identifiers performed only if necessary.
• MSSQL: Remove dependencies for field before ALTER COLUMN.
• Support of CharSet-prefix for strings was added (e.g.: select _unicode_fss 'ABCD' from rdb$database).
• Support of Interbase v 4.0 restored (extract metadata).
• Domains CHECK altering via ALTER DOMAIN DROP CONSTRAINT / ADD CHECK (IB6.0 and up).
• TTableDataComparer.UpdateImmediately added.
• TDBStructure: Extract metadata into script.
• TTableDataComparer: comparison of tables with different structure.

Fixed Bugs:

• IB/FB: System CHECK_-triggers for views were extracted with option "WITH CHECK OPTION".
• Extraction of views with “WITH CHECK OPTION” (FB 1.5.2 truncates "OPTION" when saving view body into RDB$VIEW_SOURCE).
• REVOKE performed before assigning of rights (GRANTs) - fixed.
• Temporary dropped indexes (when updating other objects) was not be restored afterwards - fixed.
• EXTERNAL [FILE] parsing.
• NEW/OLD context-variables.
• "GLOBAL"-keyword removed.
• TxxxSQLExec closes connection after ExecuteScript - fixed.
• During updating of domain type the constraints on corresponding fields was not dropped - fixed.
• Temporary dropped constraints (and possible some other DB-objects) was not restored at first comparison pass.
• Updating of Precision, Scale for Decimal/Numeric (domains, table fields).
• Using of DBC VCL components may lead to Delphi IDE freezing in some cases - fixed.
• Comparing of tables with compare domains option turned off may lead to “Index out of bounds” error - fixed.

Version 2.2.27.0 (25 January 2005)

Implemented Features:

• Delphi 2005 support.
• Comparing of the MySql scripts was implemented.

Fixed Bugs:

• Comparing of the TIME fields in FireBird 1.x - fixed.
• The Database Comparer worked with COMPUTED BY fields incorrectly - fixed.
• The "Invalid factor in expression" error occured when comparing script statements with the row_count keyword - fixed.

Version 2.1.21.0 (4 October 2004)

Implemented Features:

• Starting from now the Ya / FB extensions of the EXCEPTION command are fully supported.
• The updating of the View objects has been improved.
• The deletion of the Domain objects which are used in Views has been improved.
• Starting from now the database Triggers are modified with the ALTER command instead of using the DROP / CREATE pair (IB6.x and higher).
• The data type conversion is performed using ALTER COLUMN / ALTER DOMAIN commands if it is possible (IB6.x and higher).
• Currently the database object descriptions are included into the resulting update script (using the DESCRIBE command).
• The Numeric / Decimal data type extraction has been improved.
• Starting from now the dbc script parser does not require for the AS specification in the CREATE DOMAIN ctatements: CREATE DOMAIN domain [AS] <datatype>...

Fixed Bugs:

• Cross references for the stored procedures are not used in the comparing process - fixed.
• The new View objects are not created - fixed.
• The inactive triggers look activated within the resulting update script - fixed.
• The ALTER DOMAIN command is generated incorrectly - there are some superflow commands like DEFAULT, NOT NULL etc.
• The table field constraints are not dropped with Alter Domain and Alter Column commands.
• From now on the data conversion for BLOB fields is disabled for both the Alter Domain and Alter Column commands.

Version 2.0.14.0 (27 May 2004)

Implemented Features:

• Starting from version 2.0 components have full support of the Interbase Objects (IBO) library.

Version 1.1.0.10 (5 May 2004)

Implemented Features:

• Extraction of the database triggers has been improved.
• The OLDFIBSYNTAX conditional directive has been added to the dbcIBDatabase.pas module. This directive is used for compatibility with old FIBPlus library versions.
• Script metadata extraction has been improved. From now the resulting script statements are separated with TERM delimiters.

Fixed Bugs:

• Comparing of the DEFAULT field parameters has been fixed. From now if this parameter is equal to NULL for the specified DOMAIN, the DEFAULT value will be taken from the corresponding field definition.
• Comparing of the CHARACTER SET parameters for calculated string fields was removed.
• Interbase parser error occured when parsing stored procedure or trigger which contain the term ('^') symbol - fixed.
• Grants on system tables were not compared - fixed.
• Grants on View objects were dropped after comparing - fixed.

Version 1.0.0.8 (17 March 2004)

Implemented Features:

• Database Comparer VCL v. 1.0 released!
• Starting from now you can compare one database with another database or database with SQL/DDL script or even two SQL/DDL scripts.
• Support of universal triggers for Yaffil and FireBired 1.5.
• Processing of external table fields located in external files. The algorithm of update of the external table fields is the same as for regular table fields.
• BOOLEAN fields handling (for IB 7.x).