Datanamic SchemaDiff is a program for comparing and synchronizing schemas for databases. It lets you compare and sync tables, views, functions, sequences (generators), triggers, stored procedures, and restrictions between databases. Multiple databases can be supported. It is possible to compare and synchronize Oracle, MySQL, MS Access, MS SQL Server, InterBase, Firebird, and PostgreSQL schemas for databases.

Datanamic SchemaDiff is a database schemas comparator as well as a synchronization software. It can generate synchronization scripts and lets you see the differences between schemas for databases.

Datanamic SchemaDiff will give you the complete picture of all differences between databases. When your databases are compared, you can see the differences and then create the required (database-specific) script for synchronization to change the destination database to ensure it is identical to the original database.

The program uses natural connections with Oracle, MS SQL Server, MySQL, MS Access, Interbase, Firebird, SQLite, and PostgreSQL. For each database supported, the database-specific comparison routines are utilized. Specific synchronization scripts/routines are developed to synchronize particular synchronization of databases.

• Compare and synchronize database schemas.
• Generate synchronization scripts
• Visualize the differences between database schemas
• Intelligent mapping of (renamed) database objects
• Includes a command-line utility

Datanamic SchemaDiff MultiDB Great Features:

• Support for multiple databases.
  Databases supported:
  • Oracle 8, 9, 10, 11, 12, 18 and 19.
  • MySQL 4, 5, 6, and 8.
  • PostgreSQL 7, 8, 9, 10, 11 and 12.
  • MS SQL Server 2000, 2005, 2008, 2012, 2014, 2016, 2017 and 2019.
  • MS Access 2000, 2003, 2007, 2010 and 2013.
  • Microsoft SQL Azure.
  • Firebird 1.x, 2.x and 3.x.
  • InterBase 6, 7, 2009, and XE.
  • SQLite 3.0 and higher.
• Cross-database versions comparison.
  You can, for example, compare (and synchronize) a PostgreSQL 9 and a PostgreSQL 10 database. Note that cross-database platform (e.g., Oracle - MS SQL) is not supported.

• Database schema to database schema comparison.
  Connect to two databases and compare the objects in those databases.
• SQL script to database schema comparison.
  Connect to a database, select a SQL script representing a database, and compare the objects in both sources.
• Schema mapping.
  Mapping schemas enables you to compare database objects that belong to the same or different schemas.
• Intelligent object mapping.
  Mapping is used to connect the objects to be compared. Mapping of database objects in source and destination databases is done based on names. If no object with the same name was found, intelligent routines are used to determine if an object must be mapped to an object with another name. It detects renamed database objects.
• Compare all database object types. Compare tables, procedures, indexes, views, triggers, constraints, etc.
• Generate HTML reports with database differences.
• Fine-tune the comparison with the comparison options.
  You can control what is compared and what is seen as a difference. Use the comparison options such as case insensitivity, ignore constraints, and 30 other options.

• Synchronize complete database or selected objects.
  You can select the database objects you want to synchronize.
• Intelligent alter script generation.
  Generated synchronization script handles object dependencies.
• Fine-tune the synchronization process with synchronization options.
  You can ignore table elements or objects descriptions... for synchronization.

• Visual representation of differences.
  A side-by-side, color-coded comparison overview makes it easy to pinpoint similarities and differences between two database objects.
• Summary of differences between two databases.
  The summary includes objects in the source but not in destination (or vice versa), identical objects, and the totals of selected objects. You can easily copy the summary to the clipboard.
• Object type filtering.
  Filtering the comparison results enables you to limit the display of objects to certain types of database objects (for example, show only tables and/or views).
• Status filtering.
  Filter the comparison results based on the comparable object's status (identical, different, etc...).

• Automated object comparison and synchronization.
  A command-line utility is included to automate your compare and synchronize process.
• Project-oriented.
  Save your comparison plan to a SchemaDiff project.