Database Comparer Issue Tracker: http://www.clevercomponents.com/bugtracker/ ------------------------------------------- 21.01.2012 v.4.0.0.1608. - Application interface: "Delete Folder" command implemented for database-aliases (left panel). - MSSQL: SELECT-directive ...FOR BROWSE/XML fix. Issue: http://www.clevercomponents.com/bugtracker/view.php?id=225 20.01.2012 v.4.0.0.1605. - FB: Common Table Expressions (CTE) fix for CREATE/ALTER VIEW statement. - FB: Common Table Expressions in procedure body fix. - MSSQL: Default values for function/procedure varibles fix. 19.01.2012 v.4.0.0.1600. - Compiled with Delphi2010. Unicode support. 23.03.2010 v.3.2.0.1573 IB: - Menu-> Tools-> "Sync Tables" fix - ignore computed fields. IB 2.5: - Hexadecimal Numeric and Binary String Literals support added. (0x0F0000000, x'deadbeef') 15.03.2010 v.3.2.0.1571 Oracle: - Datatype fixes: VARCHAR(n [ CHAR ] ), TIMESTAMP [ (precision) ]. 12.02.2010 v.3.2.0.1570 MSSQL 2008: - Extract metadata from database fix (extract users). - Support for dublicate index names for different objects (tables, views). 05.02.2010 v.3.2.0.1568 - Oracle: COMMENT ON COLUMN fix. 05.02.2010 v.3.2.0.1567 - Oracle: ASC/DESC for index-fields fix. 08.07.2009 v.3.2.0.1563 - IB/FB: SUSPEND for empty body of procedure. 11.11.2008 v.3.2.0.1558 - FB2: Extract DATABASE TRIGGERs from database (fixed by Alexander Khvastunov). - DBC VCL: FB2 version changed (property IBServerOptions.SQLServerVersion): st_firebird_2x => st_firebird_20, st_firebird_21, st_firebird_25 (fixed by Alexander Khvastunov). - FB2: EXECUTE BLOCK support added. 21.08.2008 v.3.2.0.1556 - FB21: OVERLAY function support added. - IB/FB: Views recreate fix (issue by Kadri Izer). 08.01.2008 v.3.2.0.1554 - #0000019: IB/FB: - SELECT FROM SELECT fix (issue by skopaliks). 24.12.2007 V.3.2.0.1553 - MSSQL: Common table expression fix, ROW_NUMBER() OVER (PARTITION...) fix (David Wilson issues). 24.12.2007 v.3.2.0.1551 - TableDataComparer quoted identifiers fix. 18.12.2007 v.3.2.0.1548 - FB2: POSITION function fix. 03.12.2007 v.3.2.0.1545 - FB2: Function POSITION support added. 29.11.2007 v.3.2.0.1543 - Filtering objects names (like PREFIX_%). Configured in DB-Alias. - DBC VCL: Properties added for TxxxExtractor-components: IncludeObjsNames, ExcludeObjsNames. Events added: OnAcceptObj, OnAccept_Obj. 11.11.2007 v.3.2.0.1541 - DBC VCL: Free Pascal Compiler (FPC) "Lazarus" support added. (c) by Attid (Igor Tolstov). - #0000006: IB/FB: Compare COLLATION for domain-fields. 30.10.2007 v.3.2.0.1537 - FB2: GLOBAL TEMPORARY TABLE support added. - FB21: FOR WITH... SELECT... fix. 28.10.2007 v.3.2.0.1535 - IB/FB: Fix Access Violation for differenced ClientLibrary's. - FB21: Fix to ectractiong default value for procedure parameter, defined with domain. - IB/FB: Function LEFT, RIGHT for ver. >= Yaffil 1.x. 26.10.2007 v.3.2.0.1532 - Allow wildcards in script file-names (like "*.SQL" "*.SP" "DB.SQL"). 18.10.2007 v.3.2.0.1531 - MSSQL->IB/FB: Convert TEXT-datatype to BLOB SUB_TYPE TEXT. - DBC VCL: TDBComparer.fInternalSQLExec memory leak fixed. - FB21: Procedure params fix (DOMAIN, TYPE OF DOMAIN). 11.10.2007 v.3.2.0.1525 - MSSQL: Extract fields for UNIQUE-constraints fixed. 10.10.2007 v.3.2.0.1524 - FB2: Database triggers support added. - FB2: UPDATE OR INSERT... MATCHING... RETURNING... - FB2: TYPE OF . - FB2: MERGE-statement. - FB2: Common Table Expressions (WITH... SELECT...). - Fix parsing for "update AS ...", "insert into
AS ...". 11.07.2007 v.3.2.0.1520 - IB/FB: Create generators before views creation. 25.05.2007 v.3.2.0.1518 - MSSQL: - Fix for procedures/triigers/views text compare. - Fix on modify functions used in default-constraints. - Fix for table-valued functions (RETURNS TABLE). - TableDataComparer: RecEqual property added. 03.05.2007 v.3.2.0.1512 - IB/FB: Fixed loop on metadata extracting (by Steffen Nyeland issue). 02.05.2007 v.3.2.0.1510 - Oracle: "type of object" fix, triiger headrer fix. 10.04.2007 v.3.2.0.1507 - IB/FB: "STARTS WITH", "ALTER EXCEPTION" fix. - 02.03.2007 v.3.2.0.1503 - MSSQL: - OPENDATASOURCE, OPENROWSET, OPENQUERY fix. - DUMMY removed from reserved keywords. - Temporary names fix (begins with #, ##). 27.02.2007 v.3.2.0.1502 - MSSQL: - BEGIN TRY/CATCH fix. - Remove end spaces into procedures/triggers/views body. - ALTER TABLE ENABLE/DISABLE TRIGGER fix. 20.02.2007 v.3.2.0.1501 - ASA7, 8: Extract metadata from DB fixes. 12.02.2007 v.3.0.2.1496 - IB/FB: RDB$DB_KEY with NEW./OLD. context-variable fix. - IB/FB: SET BLOBFILE fixed for external SQL-script. - IB/FB: CHAR/NCHAR (VARYING) datatype fixes. - Databases profile comparison added. - Update application main icon for Windows Vista (max. size 256x256 px). 09.01.2007 v.3.2.0.1488 - MSSQL fixes: - Negative values for IDENTITY. - DEFAULT-value in procedure/function call. - UPDATE [ TOP ( expression ) [ PERCENT ] ]... - FK from DB extract fix - quoted identifiers. - Schema for default-constraints (script parsing). 08.01.2007 v.3.2.0.1482 - Support folders in DB-aliases list (interface). - IB/FB: Update description for view-fields fix. 29.12.2006 v.3.2.0.1448 - MSSQL2000: - Extract indexes from database fix. - IDENTITY column fix (parsing from script). - Table-values functions: extract from database, create fix. - Extract computed columns from database. - Convert simple-type column to computed column. 18.12.2006 v.3.2.0.1428 - "Custom connection string" for ADO-connection (optional). - SybaseASA: Inactive database auto-start implemented (need specify full path name in "Database name" field). - IB/FB: Extract Numeric/Decimal datatype fix (extract from DB). 13.12.2006 v.3.2.0.1415 - DBC VCL: "Timeout expired" fix (ADOConnection). - MSSQL2005: new features support: - Extract metadata from sys.. - SCHEMA's support added. - TYPE, XML SCHEMA COLLECTION, XML INDEX. - XML datatype. - Database triggers. - Remove diagram support db-objects from extracted metadata (microsoft_database_tools_support). - Descriptions extraction fix for databases with CompatibilityLevel = 80 (from MSSQL2000). - MSSQL: UpdateColumnPosition (optional) - recreate tables with data copy. 04.12.2006 v.3.2.0.1407 - MSSQL 2005 fixes. - DBC VCL: Memory leak fixes (TTrgData.Destroy, TCustomScriptExtract). 11.11.2006 v.3.2.0.1398 - DBC VCL: TDBCCustomConnection: TestconnectInfo() method added. Return test connect information: SQL server version, database params & etc. 04.11.2006 v.3.2.0.1397 - Sybase ASA: ALTER COLUMN implemented: datatype conversion, null/not null, default value. - Sybase ASA: Primary key CLUSTERED. - Sybase ASA: Default value parsing fix. 25.10.2006 v.3.2.0.1395 - IB/FB: Doublicate RECONNECT fixed (before drop primary key). 17.10.2006 v.3.2.0.1394 - IB/FB: Datatype conversion fix(NUMERIC/DECIMAL). 02.10.2006 v.3.2.0.1393 - IB/FB: Connection fix (hostname). 11.09.2006 v.3.2.0.1392 - DBC VCL: TObjs memory leak fix. - TableDataComparer: GUID-field fix. 29.08.2006 v.3.2.0.1391 - MySQL: "Case sensitive identifiers" option added. 28.08.2006 v.3.2.0.1390 - DBCVCL: dbcTableDataComparer.pas - Delphi5 compilation fix. - DBCVCL: 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...). 01.08.2006 v.3.2.0.1386 - MSSQL: Function USER - parsing fix. 29.07.2006 v.3.2.0.1385 - TableDataComparer: Blob-fields fix for "Update Immediatelly" option. 28.07.2006 v.3.2.0.1384 - MSSQL: Parse function ROW_NUMBER() OVER(...). - MSSQL: Index options parse fix (WITH...). - TableDataComparer: Added support for BOOLEAN, GUID datatypes. - Oracle: ENABLE/DISABLE for NOT NULL column-constraint. - MSSQL: Constraints: NOT FOR REPLICATION, WITH VALUES. - MSSQL: Added support for russian identifiers. 25.07.2006 v.3.2.0.1380 - Oracle: Extract metadata from database fixes. - IB/FB: Negative values for SET GENERATOR... fix. - DBCVCL: Added support for IBDAC-connection. 04.07.2006 v.3.2.0.1377 - IB/FB: BLOB SUBTYPE TEXT - charset fix. 23.06.2006 v.3.2.0.1375 - TableDataComparer: BIGINT-datatype fix. - TableDataComparer: Records deleting fix. - Interface: new icons for commands. 19.06.2006 v.3.2.0.1374 - IB/FB: "IB Services" (Backup/Restore/Validate) - client library fix. 15.06.2006 v.3.2.0.1372 - MSSQL: Case sensitive database fixes. - IB/FB: "Test connect" - client library fix. 13.06.2006 v.3.2.0.1371 - IB/FB: Grants for views fix. 09.06.2006 v.3.2.0.1370 - MSSQL: Case sensitive databases fix. 04.06.2006 v.3.1.0.1369 - Oracle: Varchar2(1) fix. - Oracle: CLOB-field for TableDataComparer fix. 19.05.2006 v.3.1.0.1367 - MSSQL: Fix CREATE DATABASE parsing. 26.04.2006 v.3.1.0.1365 - ASA: EVENTs support added, small fixes. - Oracle: GLOBAL TEMPORARY TABLEs support added. 20.04.2006 v.3.1.0.1356 - MSSQL: IDENTITY in expession - parse fix. IDENTITY (data_type [ , seed , increment ] ) AS column_name 19.04.2006 v.3.1.0.1353 - IB/FB: PLAN expression - parsing fix. 14.04.2006 v.3.1.0.1351 - ASE: Script header fixes, compare database options. 12.04.2006 v.3.1.0.1350 - ASE: TableDataComparer fix (unknown field "xtype"). 08.04.2006 v.3.1.0.1348 - ASA: GRANT fixes. 06.04.2006 v.3.1.0.1347 - ASA fixes: - CREATE DOMAIN parsing fix. - GO-terminator fix (the identifiers beginning with GO... were interpreted as terminator). 03.04.2006 v.3.1.0.1345 - ASA: ASA v.8.x - extracting metadata fixes (Table SYSCONSTRAINT not found). 28.03.2006 v.3.1.0.1343 - IB/FB: ALL-keyword into arguments of aggregate functions. 25.03.2006 v.3.1.0.1342 - MSSQL: Parser fixes: CREATE DATABASE, execute procedure wihtout params, SELECT TOP * FROM
. - MSSQL: Fixes - extracting table-valued functions from DB, updating table-values functions. 23.03.2006 v.3.1.0.1341 - IB/FB: ALTER TRIGGER parse fix. - IB/FB: STRING UDF-parameter fix (string length). - IB5: Fix - 'Can't find procedure isc_service_attach in gds32.dll'. 21.03.2006 v.3.1.0.1337.Release 17.03.2006 v.3.1.0.1330 - IB/FB: Extract procedures from script fix (Database Comparer ignored comments before AS-keyword). - PostgreSQL: v.8.0 extract metadata fixes. - PostgreSQL: Datatype replace for fields (ALTER COLUMN TYPE), replace NULL/NOT NULL for fields. - SybaseASE: Added support for grant permissions - TRUNCATE TABLE, UPDATE STATISTICS, DELETE STATISTICS. - Oracle: Extract metadata and comparing fixes. - Oracle: ALTER TABLE DROP ( ) fix. - Oracle: Updating sequence's params (ALTER SEQUENCE ...). 16.03.2006 v.3.0.0.1329 - IB/FB: Fixed Blob-file support for external script (SET BLOBFILE ). - IB/FB: Parse SELECT from script. 13.03.2006 v.3.0.0.1326 - PostgreSQL: Extractiong and comparing: Operator, Operator class, Conversion. - PostgreSQL: DROP-statements fixed for Update script. - IB/FB: Replacing VIEW, used in CHECK-constraint fix. 09.03.2006 v.3.0.0.1318 - PostgreSQL: - Script parser fixes (parsing CHECK-constraints, REFERENCES in table fields). - DROP FUNCTION () generated without params-list. 07.03.2006 v.3.0.0.1316 - IB/FB: Bug related to creating/deleting of roles when comparing databases (error was introduced in build 1297). - MSSQL: Float datatype fix. 06.03.2006 v.30.0.1313 - MSSQL: Parsing of trigger's headers fixed: {FOR / AFTER / INSTEAD OF}, [WITH APPEND], [NOT FOR REPLICATION]. - TableDataComparer: IB/FB Dialect 3 table names fix. 05.03.2006 v.3.0.0.1312 - Oracle: - Execute script fix (Error: Command text must be not empty). - Extract packages, types from database. - TableDataComparer: Output format fix for float values. 02.03.2006 v.3.0.0.1311 - PostgreSQL: v.8.0 fix (relation "pg_catalog.pg_authid" not found). - SybaseASE: Various parser fixes (msgconsume, msgpublish, msgrecv, msgsend, java procedures/functions). 02.03.2006 v.3.0.0.1308 - IB/FB: VARCHAR(1) fix. - IB/FB: Missing "AS" when parsing triggers (error was introduced in build 1272). 02.03.2006 v.3.0.0.1306 - PostgreSQL fixes: - Boolean datatype. - Qualified names - .. - UNIQUE INDEX. - FK: on update/on delete action fix. - Loading script from file. - Extract metadata (create script). - Extract OWNER properties for database objects. 28.02.2006 v.3.0.0.1299 - MSSQL: Parsing of GRANT statement fixed (...[AS grantee]). 27.02.2006 v.3.0.0.1297 - MySQL: - Parsing of Unique key fixed (length of the key was ignored). - Engine MEMORY/HEAP fixed (identified as separate statements). - Tables creation algorithm improved (constraints, keys). - DBC VCL: TTableDataComparer - property IngnoreComputedFields added. - Sybase ASE: Support of roles, logins, users and rights added. 24.02.2006 v.3.0.0.1295 - Various improvements related to work with Sybase ASE. - IB/FB: Field datatypes conversion improved (using update of system tables), controlled by AllowDatatypeConversion option. 23.02.2006 v.3.0.0.1289 - Comparing of scripts and databases for Sybase ASE (initial implementation). 17.02.2006 v.3.0.0.1278 - IB/FB: Relations were extracted only for triggers (error was introduced in build 1272). - Database alias create/copy routine fixed - server version was not displayed correctly (AV if copied). - Long path to client library causes exception (database alias). 16.02.2006 v.3.0.0.1272 - IB/FB: Identifiers starting with "_" was not quoted. - IB/FB: UDF calls without return params (type RDB$SET_CONTEXT). - IB/FB: Parsing of CREATE TRIGGER... without [POSITION n] fixed. - MSSQL: Extraction of Defaults from database for MSSQL2000/2005 was improved. 13.02.2006 v.3.0.0.1261 - MSSQL: - Computed columns. Parser fixes. 10.02.2006 v.3.0.0.1258 - MSSQL: - Script parser fixes. - Output parameters for proc/func: CURSOR, TABLE. 09.02.2006 v.3.0.0.1250 - Table data comparer: Select-SQL field added. 07.02.2006 v.3.0.0.1239 - IB/FB: Ignore REINSERT-statement (generated by IBExpert). - MSSQL: Script parser fixes. 04.02.2006 v.3.0.0.1232 - Yaffil: Additional functions support added (LEFT, RIGHT, TRIM, PAD, POSITION, CASE & etc.). 01.02.2006 v.3.0.0.1224 - IB/FB: Client-library for db-aliases, for DBCConnectionXXX-componernts. - MSSQL: Parser fixes for nested statements. Hex-constants support added (0xNN...). - MSSQL: Fix to extract datatypes from DB: Numeric/Decimal/Real/Float. - PostgreSQL: Comparing databases (first implementation). 25.01.2006 v.3.0.0.1206 - TableDataComparer: added support for Oracle and PostgreSQL. - Field description update fix. - For IB/FB use FIB (later IBX) for access to databases. FIB support dynamic loading for client library (gds32.dll). 19.01.2006 v.3.0.0.1188 - IB/FB: Fixed bug with extract metadata for old ODS version (field RDB$PRECISION for UDF-params). 17.01.2006 v.3.0.0.1181 - MySQL: Support for GIS (geographic information system) datatypes added, Processing of index for SPATIAL KEY (INDEX) statement added, Processing of table options CREATE [OR REPLACE] improved, Processing of VIEW's added. - Fixed bug with displaying of wrong number of objects in DB-Tree in "Show differences only" mode. 12.01.2006 v.3.0.0.1172 - Oracle: Replace DEFAULT-value for table fields. - MySQL: FULLTEXT INDEX support added. - FB2: TRIM-function support added. 11.01.2006 v.3.0.0.1170 - FB2: "SELECT FROM SELECT" fix. 06.01.2006 v.3.0.0.1167.Release - Fix for update computed fields. 04.01.2006 v.3.0.0.1160 - DBC VCL: MyDAC support (TDBCConnection). 28.12.2005 v.3.0.0.1149 - MSSQL: Fix grants extracting and comparing. - MSSQL: Fixed DB-script compare. 21.12.2005 v.3.0.0.1148 - Fix: duplicate alter on update reecursive procedure with changed params-list. 19.12.2005 v.3.0.0.1145 - DBC VCL: DB Express support added, TDBCConnectionDBX. 14.12.2005 v.3.0.0.1139 - TableDataComparer: Sybase support added, small fixes. 03.12.2005 v.3.0.0.1134 - Sybase: PUBLICATIONs extracting and comparing. 01.12.2005 v.3.0.0.1132 - Sybase(ASA): Extracting metadata from DB, comparing DB-structures, updating DB-structure, external script executing. 29.11.2005 v.3.0.0.1128 - IB/FB: "Ignore IBE$... objects" option (not extract IBExpert-objects). 28.11.2005 v.3.0.0.1127 - IB/FB: System CHECK_-triggers for Views with option "WITH CHECK OPTION" now not extracted. 25.11.2005 v.3.0.0.1125 - UDF BY DESCRIPTOR fix. - Extraction Views with WITH CHECK OPTION is modified (FB 1.5.2 truncate "OPTION" at save view in RDB$VIEW_SOURCE). 21.11.2005 v.3.0.0.1115 - In DB-Tree in lists of dependencies of constraints showed as the empty lines. 19.11.2005 v.3.0.0.1108 - Loading and execution of external script MSSQL in UpdateScript are modified. Before loading it is necessary to choose alias (database). For MSSQL execution of text scripts in Unicode is supported. - Dependencies of grants with the objects are added. On removed objects REVOKE any more it is not done. For temporarily deleted objects (and then restored) grants also are restored. 18.11.2005 v.3.0.0.1105 - REVOKE it is carried out before distribution of the rights (GRANTs). - It is temporary dropped indexes (for updating other objects) could not be restored then. - MSSQL: Unnamed DEFAULT-constraints were ignored at analysis of a script. - MSSQL: MSSQL2000-keywords are added, is realized identifiers-quoting only if necessary. - MSSQL: The new field with attribute NOT NULL is created now at once with DEFAULT. - MSSQL: At comparison did not drop (and not replaced) DEFAULT-constraint. 17.11.2005 v.3.0.0.1100 - MSSQL: Comparison of DB-objects with case-sensitive identifiers is modified. - MSSQL: Creation DEFAULT-constraints before replacement NULL -> NOT NULL for corresponding fields. - MSSQL: Remove dependencies for field before ALTER COLUMN. 16.11.2005 v.3.0.0.1099 - MSSQL: Indexes, constraints extraction fixes. 15.11.2005 v.3.0.0.1098 - EXTERNAL [FILE] parsing fix. 14.11.2005 v.3.0.0.1095 - DBCVCL: TTableDataComparer - clear Blob-fields fix. 12.11.2005 v.3.0.0.1086 - DBCVCL: For TDBCConnection connect to Sybase implemented (using cnADO). - DBComparer: [Test connect] for Sybase (Add/Edit Alias). Support Sybase for "SQL editor". 11.11.2005 v.3.0.0.1083 - CHARSET fixes. - DEFAULT-value fixes. Added support for expression in default. 10.11.2005 v.3.1.0.1077 - Script parser implemented via stream. 09.11.2005 v.3.0.0.1072 - IB/FB: View ... WITH CHECK OPTION fix (parser error). - Domain ... CONSTRAIN CHECK fix (extract metadata). 08.11.2005 v.3.0.0.1070 - NEW/OLD context-variables fix. - DBC VCL: TTableDataComparer.BeforeOpen event (for UpdateImmediatelly = True). 04.11.2005 v.3.0.0.1067 - USING INDEX fix (parse from script). 31.10.2005 v.3.0.0.1065 - CharSet-prifix for strings support added. (by example: select _unicode_fss 'ABCD' from rdb$database) 30.10.2005 v.3.0.0.1064 - InterBase v.4.0 fixes (extract metadata). - Change database default character set fix. 29.10.2005 v.3.0.0.1060 - Replacement CHECK at domains through ALTER DOMAIN DROP CONSTRAINT / ADD CHECK (IB6x and above). - IB/FB keywords fixes. - New option "Extract only compared objects" (at comparison on the selected objects of a DB). - Menu-> Tools-> "Sync Data" fixes. There were problems with copying data in tables with calculated fields. 24.10.2005 v.3.0.0.1027 - Completions on logic of updating. 23.10.2005 v.3.0.0.1026 - FB2: CURRENT_TIME [STAMP] [(precision)]. 22.10.2005 v.3.0.0.1024 - DBC VCL: cosmetic editing components icons. - Options of a command line (comparison on a DB, updating of a DB) are expanded: DBCOMPARER.EXE /? - Optionally updating of positions for fields (Update field position). 20.10.2005 v.3.0.0.1019 - Processing of ARRAYs. ALTER COLUMN change of dimension does not support, but a certain converting (change of borders) is possible at set of option "Allow datatype conversion", but do not do it at presence of data in the table - the result is unpredictable. The field of the table (if it does not contain data) is possible also in this case drop, DBComparer will create a new field. - Fix on extraction of dependencies. At analysis of a body of the trigger not extract dependendencies on fields of own table - NEW., OLD.. - DBC VCL did not undertake: TTableDataComparer and Connection - Commit fix. 19.10.2005 v.3.0.0.1015 - DBC VCL: TTableDataComparer. UpdateImmediately - a mode of direct updating of data at comparison. In ScriptOptions field GenerateScript is added. At set UpdateImmediately in True GenerateScript it is automatically established in False, disconnecting formation of a script. - Fixes for transactions in different TDBCConnectionXXX, active transaction at closing connection comes to the end commit. 18.10.2005 v.3.0.0.1004 - DBC VCL: TTableDataComparer.OnGetDataValue event. - FB: "GLOBAL"-keyword removed. - Process of converting of types of fields for columns is advanced. - Selective comparison of grants on roles, users, objects of a DB. (VCL: TDBComparer. CompareObjects - coRoleGrant, coUserGrant, coObjGrant). - DBC VCL: TxxxSQLExec always close connection after ExecuteScript - fixed. Connection remains in an initial condition (as before ExecuteScript). - DBC VCL: TTableDataComparer: RecInserted, RecUpdated, RecDeleted (counters of the added, updated, removed records - after comparison). - DBC VCL: TTableDataComparer.OnAddResultSQL event. 10.10.2005 v.3.0.0.972 - IB/FB: At replacement of type of the domain not deleted constraints on corresponding fields of tables. - Precision, Scale conversion for Decimal/Numeric (domains, table fields). 06.10.2005 v.3.0.0.969 - Constraints USING DESC INDEX fix. 05.10.2005 v.3.0.0.968 - DBC VCL: TDBStructure. Extract metadata to script. 04.10.2005 v.3.0.0.962 - DBC VCL: TTableDataComparer. Reception of a script with data of one table if to not specify TDBCConnectionTarget, TableNameTarget (a unloading of records of the table in a script). 29.09.2005 v.3.0.0.961 - FB2: Default values for proc-papams - fix. - FB2: ...ALTER COLUMN SET DEFAULT / DROP DEFAULT. 29.09.2005 v.3.0.0.959 - MySQL: SET NAMES , SET CHARACTER SET . 24.09.2005 v.3.0.0.957 - Added keywords for LocalSQL. 17.09.2005 v.3.0.0.955 - VCL: TTableDataComparer - CustomKeyFields property fixes. - IB/FB: PLAN-clause fix. - TableDataComparer - the format of a writing in a target script is corrected for Date, Time, TimeStamp. 06.09.2005 v.3.0.0.946 - IB/FB: OPEN-keyword fix. - TableDataComparer: KeyFields fix, keywords for Local DB. 06.08.2005 v.3.0.0.920 - MySQL: Change column position (MODIFY COLUMN ... FIRST/AFTER ...). 05.08.2005 v.3.0.0.917 - MySQL: Processing cpecial chars for description, default-values. - IB7: TRUE, FALSE, UNKNOWN keywords. 04.08.2005 v.3.0.0.913 - At extraction of metadata there was a mistake on bases IB7.x "Field 'RDB$DESCRIPTION' not found" (extraction of generators), because of identical versions ODS=11 (FB2/IB7). Definition of specificity ODS now is made by original adaptable technique by A. Khvastunov. - IB7: GLOBAL TEMPORARY TABLE's support. - SET TERM fix. - DBC VCL: TTableDataComparer. Comparison of tables of local DB - Paradox, dDASE (through TDBCConnectionBDE). - DBC VCL: Unit dbcConnection_BDEDB.pas for universal TDBCConnection. - DBC VCL: TTableDataComparer. Processing special chars for MySQL strings. - DBC VCL: TMySQLExec did not work with BlobFileName at execution of a script (parser did not allocate INSERT, UPDATE. DELETE at analysis of a script) - fixed. - MySQL: OnUpdate/OnDelete rule (FK). - MySQL: Ignore incorrect View's at extraction of tables of a DB (externally it looked as set of empty tables ALGORITHM without fields in DB-Tree after comparison of DB). 31.07.2005 v.3.0.0.908 - MS SQL: Support index options: [ WITH < index_option > [ ,...n] ]. - MS SQL: Support identifiers, begins with "_", "@". - MS SQL: Ignore FILEGROUP (compare option). - DBC VCL: In components TDBComparer, TIBSQLExec were not remembered exposed in design-time values of fields in IBServerOptions. 30.07.2005 v.3.0.0.905 - DBC VCL: Notification fixes (continued). - DBC VCL: Const dbSQLAnywhere replace to dbSybase. - MySQL: COMMENT for fields support added. - Quoted strings fixes. 28.07.2005 v.3.0.0.902 - DBC VCL: Notification fixes. At use component DBC VCL there could be lags of applications at closing, lags opened in Delphi IDE projects at closing or at an output from Delphi IDE. 27.07.2005 v.3.0.0.895 - IB/FB: Fix tables compare with uncheck domains compare (error - Index out of bounds). - SET BLOBFILE implemented for all supported DB (InterBase, MySQL, MSSQL, LocalSQL) - TxxxSQLExec-component. 26.07.2005 v.3.0.0.896 - MS SQL: RowGuidCol fixes. - MS SQL: ALTER COLUNN implemented for change DataType, Collation, Nullable, RowGuidCol. - DBC VCL: TDBCConnectionFIB fix (transaction is active). - Converting simple field (with Default è Not Null) into Computed field generate Default/Nullable changes - fixed. 25.07.2005 v.3.0.0.892 - MySQL, MS SQL: Load and execute external script from file (Execute Script). - MS SQL: Fixed DB/script compare for triggers, procedures, defaults. - TTableDataComparer: IncludeBlobs property. - TableDataComparer: MySQL tables compare added. 23.07.2005 v.3.0.0.880 - DBC VCL: TTableDataComparer - OnGetKeyFields, OnGetDataFields events. - DBC VCL: TTableDataComparer - comparing difference tables (see TableoptionsMaster, TableOptionsTarget properties). 20.07.2005 v.3.0.0.874 - Parser fixes (generate error without CrLf at end of text. - On load external script part of statements truncate on one symbol at end (statements with parsed bodies). - Extended error-info for db-objects (extraction from DB). - DBC VCL: TDBCConnectionBDE, TLocalSQLExec for executing LocalSQL script (BDE). 19.07.2005 v.3.0.0.870 - Into simple query ROWS interprete as table-alias (fixed): SELECT ID FROM TABLE1 ROWS 1 - DBC VCL: OnCompareFields event for TTableDataComparer. - DBC VCL: TTableDataComparer - Identifiers quoting (Dialect3). - DBC VCL: TTableDataComparer - Compare blobs fixes for CompareBlobs = True/False. - DBC VCL: TTableDataComparer - Support differences Blob-types. - DBC VCL: TTableDataComparer - Data-formatting for Result Script (optionally): Float, Date, Time, DateTime (see: ScriptOptions property). 18.07.2005 v.3.0.0.865 - FB2: IS [NOT] DISTINCT FROM . - FB2: INSERT INTO ... VALUES(...) [RETURNING [INTO ]].