The DiffDog database comparison tool supports all major relational databases, allowing you to diff databases of the same type as well as the content of equivalent tables and entire database schemas in different database types. Then, you can merge the databases in either direction.
DiffDog displays database comparisons in an intuitive graphical table representation with connecting lines to illustrate column mapping between tables.
When you compare different database types, DiffDog even resolves datatype naming inconsistencies. 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 MySQL tables, or your entire database schema between, for instance, an IBM DB2 9 database and an Oracle 11g implementation.
Automatic table mapping options let you instruct DiffDog to map columns based on name, datatype, or column position. If the results of automatic mapping are inaccurate or incomplete, you can also manually map comparisons by dragging connecting lines between table columns.
You can open detailed results windows for each table comparison, and you can filter the results to display or hide your preference of equal or unequal rows, or rows that only contain data in the table on the right or left side.
Its easy to merge differences in table content in either direction by updating individual cells or entire tables.
Database schema differencing lets you compare database structures and visually identify and merge differences. You can diff two databases of the same type, for instance a developer’s version and the production version of your database, or you can compare two schemas of different database types.
You can choose to compare individual tables, groups of tables, or entire database schemas. Your selections are displayed in the DiffDog schema comparison window. When you connect tables to begin the comparison, DiffDog automatically connects matching elements inside the tables. You can also manually connect non-matching elements to compare them or disconnect any automatic connection and re-map it differently.
When you click the compare button on the toolbar, DiffDog updates the comparison window with colors and icons to indicate differences between your database schemas.
You can merge differences by clicking either the left- or right-merge button on the toolbar. The right-click context menu offers more comprehensive merge options, including a choice to immediately open a database content comparison for the selected tables.
Whichever merge option you select, DiffDog always creates a SQL change script for you to review. You have several options for processing the SQL change script. You can save the SQL change script to a file, send the script to a SQL Editor window in DatabaseSpy, execute the SQL change script directly from DiffDog, or cancel your merge request and abandon the script.
SQL dialects and datatypes vary among relational database vendors. DiffDog accounts for these inconsistencies and generates a change script compatible with your target database syntax, even if the source database is a different type.