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
· Update UI to be dpi-aware to allow using application on higher than 96 dpi setting without scaling in Windows Vista/7
· Update application to use the system ANSI codepage rather than ASCII (US-en) codepage. Application now supports ANSI database objects that use locale's code page extended characters in their name.
· Add Rows Per Insert Statement option to generate sync script options to allow scripting multiple rows in one sql insert statement
· Add accelerators for item view commands
· Add support for generating sync script at folder level
· Fix/Update
· Add support for storing license info at local machine registry key (Site/Enterprise licenses)
· Allow disabling application automatic check for update at the machine level registry entry
· Update generate sync script/save updates as and folder level synchronize titles to display target data source server name
· Fix issue with possible deadlock/skipping last item when synchronizing folder items and last item is already active
· Update messages pan...
