CompareData is a native Windows cross-dbms program that will allow you to visually compare and synchronize data between two SQL databases using ODBC drivers.
You can retrieve all/some data for a table/view from two databases and compare the data visually to see differences highlighted on the screen. You can also compare the data of two sql queries.
Here are some key features of "CompareData":
· Compare data between two tables/views of the same or different names
· Compare columns having the same or different names and/or data types
· Compare data of two sql queries.
· Synchronize data between two tables.
· Compare Tree command to compare data of a group of tables or all tables with one command
· Compare resultsets of any size.
· Compare dbms metadata for two tables or a group of tables including: columns, indices, primary key, foreign keys, triggers and table permissions.
· You can use any two compareable columns of two resultsets as the comparison key.
Limitations:
· 30 days trial
What's New in This Release: [ read full changelog ]
New:
· Add Script Constraint As command to FK comparisons to allow scripting constraint(s) as create, drop, enable, disable (as applicable) and XML for most databases
· Add exported foreign key comparison view to table views
· Add support for comparing Ingres 9.2 column defaults, sequences, stored procedures and rules
· Add support for comparing Pervasive SQL 10 triggers and stored procedures/functions (long metadata V2)
· Add support for hosting application repository on Ingres 9.2
· Add Count Unique Differences settings command to count unique differences for a comparison column. Display unique differences for a column, if any, following the differences count in the column header and properties row summary. Display first few unique differences in tooltip for unique differences counter and for a difference value.
· Take into account foreign key constraint disabled status when determining depedencies for synchronizing folder data for DBMSs that supported disabling foreign key constr...
