Clever Database Comparer VCL v7.0.914.0 Full Source
Clever Database Comparer VCL v7.0.914.0 Full Source
The Database Comparer VCL represents 100% Delphi VCL components for Borland Delphi / C++Builder. These components allow you to compare and synchronize SQL database objects and table records for many popular databases. You can view all the differences between databases and execute an automatically generated script to eliminate all or selected only differences. The library includes more than 25 components for Database development and its code is constantly being refined and improved. Delphi / C++Builder 5-7, 2005-2009, RAD Studio 2010, XE-XE8, RAD Studio 10 Seattle and RAD Studio 10.1 Berlin support.
Database Comparer helps to compare, synchronize and update databases structure. You can compare one database with another database or database with SQL/DDL script or even two SQL/DDL scripts!
Database Comparer implements highly intelligent and robust synchronization algorithm. During first comparison step it takes Target database or Target SQL/DDL script and compare it to the Master database or Master SQL/DDL script trying to locate all structure differences and prepare final SQL script which will be applied to the Target and make its structure equal to Master structure.
At this stage Database Comparer extracts all objects, descriptions and links from both Master and Target structures and then compares actual objects from Master with objects from Target building final update SQL script. After final update SQL script is ready you can apply it to the Target database if it is available or just save it to the file and run it later.
Database Comparer also support batch mode so you can synchronize list of Target databases with given Master database or SQL/DDL script at one pass.
Features at a glance:
Compare two databases, database and SQL/DDL script, two SQL/DDL scripts
Synchronize data between two database tables
Extract database structure
Compare specific database objects or entire databases
Royalty free licensing. Free Unlimited Email support
Fully-indexed help documentation. Delphi and C++Builder demos code
Connect to most popular databases
With Database Comparer VCL components you can compare Oracle, MSSQL, MySQL, InterBase (FireBird, Yaffil), Sybase and Postgre SQL databases. SQL Server 2005 is also supported.
Most popular database libraries such as ADO, BDE, InterBase Express, FIBPlus, IBObjects and ZeosLib supported directly. MyDAC, ODAC and AnyDAC are also supported.
Version 7.0.914.0 (4 April 2018)
Implemented Features:
RAD Studio 10.2, 10.2.2 and 10.2.3 Tokyo support;
Minimum IDE versions: Delphi 7.0, C++Builder XE;
FireDAC support;
Common Table Expressions (CTE) support;
Full Firebird 3.0 support;
64-bit platform support;
Design-time and runtime packages. The components can be used by RAD Studio form designer in 64-bit projects;
New demo projects;
FB: Procedure params: NOT NULL support added;
Minor fixes and improvements.
Fixed Bugs:
MSSQL (Transact-SQL) script syntax fixes - http://barry.exp-host.ru/tracker/view.php?id=1189
TIME datatype with scale: time [ (fractional second scale) ];
Derived_table parsing, like this: SELECT * FROM (VALUES (1, 2), (3, 4) ) AS MyTable(a, b);
SET-statement, options sequence fix: SET ANSI_PADDING, ANSI_WARNINGS, ANSI_NULLS, CONCAT_NULL_YIELDS_NULL, ARITHABORT, QUOTED_IDENTIFIER ON;
CREATE INDEX with WHERE-clause;
FB3: Disabling of the system table updates for Firebird 3.0 - http://barry.exp-host.ru/tracker/view.php?id=1063
FB3: Added support for the Generator increments (START WITH... INCREMENT BY...) - http://barry.exp-host.ru/tracker/view.php?id=996
Implemented Features:
RAD Studio 10.2, 10.2.2 and 10.2.3 Tokyo support;
Minimum IDE versions: Delphi 7.0, C++Builder XE;
FireDAC support;
Common Table Expressions (CTE) support;
Full Firebird 3.0 support;
64-bit platform support;
Design-time and runtime packages. The components can be used by RAD Studio form designer in 64-bit projects;
New demo projects;
FB: Procedure params: NOT NULL support added;
Minor fixes and improvements.
Fixed Bugs:
MSSQL (Transact-SQL) script syntax fixes - http://barry.exp-host.ru/tracker/view.php?id=1189
TIME datatype with scale: time [ (fractional second scale) ];
Derived_table parsing, like this: SELECT * FROM (VALUES (1, 2), (3, 4) ) AS MyTable(a, b);
SET-statement, options sequence fix: SET ANSI_PADDING, ANSI_WARNINGS, ANSI_NULLS, CONCAT_NULL_YIELDS_NULL, ARITHABORT, QUOTED_IDENTIFIER ON;
CREATE INDEX with WHERE-clause;
FB3: Disabling of the system table updates for Firebird 3.0 - http://barry.exp-host.ru/tracker/view.php?id=1063
FB3: Added support for the Generator increments (START WITH... INCREMENT BY...) - http://barry.exp-host.ru/tracker/view.php?id=996
Only for V.I.P Warning! You are not allowed to view this text.