SQL Schema and Data Comparison in One Convenient Package

SQL Examiner Suite 2020 includes two award-winning products in one convenient package. SQL Examiner compares and synchronizes database schemas, while SQL Data Examiner performs the same task for actual data stored in databases. Learn more about database schema and data comparison.

Database Synchronization Made Easy

SQL Examiner Suite is a comprehensive solution performing fully automated comparison and synchronization of any two databases complete their structures and data. Databases in a variety of formats are supported, including all versions and editions of MS SQL Server from version 7.0 to 2017, PostgreSQL, SQL Azure Database, as well as most basic structures and objects of Oracle and MySQL databases. SQL Examiner fully supports all types of database objects found in MS SQL databases, and correctly synchronizes between different versions of MS SQL.

Keeping Databases under Version Control

SQL Examiner simplifies database schema versioning, allowing you to save a database schema to a version control system. Storing a database schema in the source control system makes it easy to deploy, update and maintain databases with little or no manual work involved. SQL Examiner works with TFS, SourceSafe, SVN, Git, and Perforce version control systems. Click here to learn more about putting your databases under version control with SQL Examiner.

Cross-Platform Comparison and Synchronization

SQL Examiner Suite works seamlessly with multiple database platforms, including all versions and editions of MS SQL Server (from 7 to 2017), SQL Azure Database, Oracle 10g,11g and 12c, MS Access, PostgreSQL 9.5.2, MySQL 4.x and higher, performing homogeneous or performs cross-platform database synchronization and migration. The Suite makes it possible to automatically compare and synchronize MS SQL, MySQL, and Oracle database schemas to each other. Compare a MS SQL Server database with an Oracle database, Oracle with MySQL, and so on.

Cross-platform schema and data comparison and synchronization between all supported DBMS servers is supported for the range of object types implemented in a similar way by the different DBMS platforms.

Scheduled Automatic Database Maintenance

SQL Examiner Suite makes database deployment and maintenance a hands-free operation. With a command-line tool supplied with SQL Examiner Suite, you can perform single-click database comparison, or schedule fully automatic comparison and synchronization of databases. Click here to learn more about scheduled synchronization. The command-line tool can perform all same tasks you can do in the GUI.

Advanced Reporting

SQL Examiner Suite offers HTML and plain-text reports, highlighting any changes the comparison has discovered. With advanced, easy to read reports, you can quickly review the differences between the two databases. Exporting of the reports to XML format allows using third-party tools to analyze the comparison results.