View Image

SQL Examiner Suite 2010 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.

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 2008 R2, 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.

SQL Examiner Suite works seamlessly with multiple database platforms, including all versions and editions of MS SQL Server (from 7 to 2008 R2), SQL Azure Database, Oracle 10g and 11g, MS Access, 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.

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.

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.

FEATURES:

Microsoft SQL Server 7.0, 2000, 2005, 2008, 2012, 2014 and 2016 database comparison
SQL Azure Database comparison and synchronization
Live databases and snapshots as comparison source
Script Database wizard
Support for all schema objects, including tables, views, stored procedures, etc.
Support for SQL Server CLR objects, including assemblies, stored procedures, triggers, UDTs, UDFs
Schema (owner) mapping