Database Content Compare and Merge Tool

Database content comparison in Altova DatabaseSpy

Database Content Comparison:

  • Compare individual tables or entire database structures
  • Automatically map equal table and column names
  • Manual table and column mapping
  • Compare two databases of the same type
  • Compare contents in databases of different types
  • Merge differences by cells directly in the results table
  • Merge differences in either direction
  • Merge differences via SQL merge script
  • Generate Restore scripts to undo changes
  • Save database comparison sets for reuse

Download Trial

Developers, data architects, and others who regularly work with databases often need to locate changes, migrate differences, or synchronize versions of database tables. Altova DatabaseSpy® 2017 includes a powerful database compare and merge tool to satisfy all these requirements. DatabaseSpy displays database comparisons in an intuitive graphical table representation with connecting lines to illustrate column mapping between tables. DatabaseSpy automatically maps columns with the same names, or you can drag connecting lines to manually map columns for comparison.

DatabaseSpy can compare different versions of a table in the same database type, or you can even compare and merge the content of equivalent tables and entire database schemas in different database types. This means you can compare the customers table in your SQL Server database with a backup copy, for example, or you can compare the contents of any tables or your entire database schema between IBM DB2 9 and Oracle 11g implementations. When you compare different database types, DatabaseSpy even resolves datatype naming inconsistencies.

Automatic table mapping options let you instruct DatabaseSpy to map columns based on name, datatype, or column position. Numerous additional options let you set preferences for comparison options, XML-aware comparison for columns containing XML data, and display of the Results view. If the results of automatic mapping are inaccurate or incomplete, you can also manually map comparisons by dragging connecting lines between table columns.

When you click the Start Comparison button in the Database Comparison Toolbar, contents of the selected tables are compared and the database comparison map is updated to show comparison results. You can open detailed results windows for each table comparison, and filter the results to display or hide your preference of equal or unequal rows, rows that only contain data in the table on the left or right, or entire columns that contain identical data.

Supported Databases:

  • Firebird 2.5
  • IBM DB2 for iSeries® v6.1, 7.1
  • IBM DB2® 8, 9.1, 9.5, 9.7, 10.1, 10.5
  • Informix® 11.70
  • Microsoft Access™ 2003, 2007, 2010, 2013
  • Microsoft® Azure SQL
  • Microsoft® SQL Server® 2005, 2008, 2012, 2014, 2016
  • MySQL® 5, 5.1, 5.5, 5.6
  • Oracle® 9i, 10g, 11g, 12c
  • PostgreSQL 8, 9.0.10, 9.1.6, 9.2.1, 9.4
  • Progress OpenEdge 11.6
  • SQLite 3.x
  • Sybase® ASE 15
Merge database differences by cells in Altova DatabaseSpy

Merge Database Differences

After you identify differences between tables, you can merge content in either direction by updating individual cells or entire tables. You can also generate a merge script that opens automatically in a new SQL Editor window.

You can even generate a Restore script to document your changes or as a precaution against accidental deletion of critical data.

Generate scripts to merge database contents in Altova DatabaseSpy

Reuse Database Comparison Sets

If you need to perform the same comparison again in the future, you can save database comparison selections in a file to easily reload. Add the database comparison file to your DatabaseSpy project so it will always be handy!