Compares and synchronizes databases structure
Database Comparer VCL is the native library for RAD Studio 11...10, XE..XE8, Delphi, and C++Builder. The components allow you to compare and synchronize databases structures (metadata) and table records of many popular databases, including Firebird, Interbase, Oracle, SQL Server, MySQL, Sybase, and Postgre SQL. The FireDAC, ADO, and IBExpress connection libraries are supported directly. Some third-party libraries, such as UniDAC, IBDDAC, IBObjects, ZEOS, AnyDAC, etc are supported as well. You can even use outdated connection methods, such as BDE or FIB to connect to your databases. The Database Comparer VCL product includes more than 40 components for the database-related development. When purchasing the Database Comparer VCL License you get: - The full sources for all suite components; - Royalty free licensing; - One year of free updates from the date of purchase; - Free unlimited support; - Detailed documentation, a lot of sample applications, fully-indexed help files. Features at a glance: - Connecting to a database and extracting the database structure. - Comparing two database structures and producing the update SQL script. - Updating the target database structure using the update SQL script and syncrhonizing two databases structures. - Comparing two SQL DDL scripts, a database and an SQL script, and synchronizing a database with an SQL script. - Comparing and synchronizing data in two tables of the same database, two databases, or even two databases of different type. - Synchronizing Firebird, Interbase, MS SQL, Oracle, MySQL, Sybase, Postgre SQL, and may other popular databases. - Comparing and synchronizing stored procedure, trigger, and function scripts. - Comparing tables, constraints, indices, triggers, generators, stored procedures, UDFs, grants, roles, and many other database objects, depending on the database type. - Extracting the database structure (metadata) to a file.