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.
Requirements:
· ODBC 3.5 compliant drivers to connect to the databases you want compare their data or a compliant ODBC-JDBC gateway and JDBC driver.
Limitations:
· 30 days trial
What's New in This Release: [ read full changelog ]
New:
· Identify Microsoft Access 2010 data sources
· Identify Microsoft Excel 2010 data sources
· Add script column as create, add, drop, modify, rename, etc to supported DBMSs
· Add script primary key as create, drop, etc to supported DBMSs
· Add script index as create, drop, etc to supported DBMSs
· Add script user table as create, drop, truncate/delete for most supported DBMSs
· Add Clear Key settings command
· Add support for using currently selected column items for open item commands
· Add support for saving selected column items as documents
· Add support for generating sql insert/update script for Oracle where sql string literal is longer than 4000 characters
· Add Fixed Char option to generate sync script right trim options
Fix/Update:
· Fix MS SQL Server numeric() identity and decimal() identity column view data type name for create column
· Fix DB2 clob, blob, dbclob, for bit data displayed column data type for create column
· Fix Firebird blob displayed column data t...
Find us on Google+
