SQLMerger description
Enables you to compare and merge data from two databases visually

SQLMerger is an easy to use software utility that helps you to merge and compare data from two databases automatically and visually. All the changes are made via a SQL script automatically created and collected through time. SQLMerger makes it very easy to upgrade and edit contents in any database.

The tool also contains a number of other toolkits to make database content editing and browsing much more comfortable than you are probably used to using the tools from the database vendor.

Here are some key features

of "SQLMerger":

· Compare contents from two tables from different databases and merge on a per-field and record basis using color visualization.
· Add lookup fields manually and automatically to ease browsing and editing with real lookup values (e.g. texts instead of keys).
· Easily see if a record is "local" to the table, "changed" or "new".
· Sort on all fields and all additional attributes, e.g. sort record in different/same categories.
· Based on the changes you make, a SQL script with inserts and updates is created for you, so you can re-execute the script on e.g. the 'production' database you want to update. (Edit the script freely before executing it. Select only part of the script to execute. Only statements with no errors, are logged in the script.)
· Manage the table specifications in projects using the well-known open, save mechanisms etc.
· Connect to any ODBC database alias.
· Many tools for merging and changing contents.


Limitations:

· 30 days trial
· Nag screen