Multi-purpose data management tool

SQL Data Examiner is not just a simple data comparison and synchronization tool. With SQL Data Examiner, you can:

• Migrate any data between SQL Server, PostgreSQL, MySQL, Oracle and any ODBC or OLE DB data source
• Compare data after data migration or replication to verify the replication success
• Consolidate data from numerous branch databases to a single central database
• Work with data regardless of format with SQL query comparison and synchronization feature
• Restore data (row level restore is supported) directly from SQL Server backup files Learn more about possible SQL Data Examiner usage scenarios

Cross-Platform Data Comparison and Synchronization

SQL Data Examiner 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 data synchronization and migration.

Use Data from Any Source

SQL Data Examiner can synchronize and compare data from any data source based on an OLE DB provider. This allows importing data from CSV and XLS files, as well as any type of files for which an OLE DB provider exists.

Synchronize and Migrate Data of Any Type

SQL Data Examiner can perform synchronization and migration of data between any databases regardless of their structure. The tool can successfully compare and synchronize data returned by SQL queries with data stored in ordinary tables. If only you can write a query to select certain data, you can compare and synchronize a database. Most importantly, the query can be either a source or a target, or the source and the target at the same time, in which case the tables referenced in that query are updated.

Scheduled Automatic Database Maintenance

SQL Data Examiner makes database deployment and maintenance a hands-free operation. With a command-line tool supplied with SQL Data Examiner, 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 Data Examiner 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.