SQL Data Examiner 2008 R2 2.2.0.20

SQL Data Examiner 2008 R2 2.2.0.20  is an easy to use cross-platform tool designed for  comparing and synchronizing database contents of all SQL Server versions from 7.0 to 2008, and also supports Oracle, MySQL and MS Access. This program  also quickly enables you to merge selected databases and to make updates.

This is a fast and easy-to-use tool that simplifies your work as a DBA or a developer. Due to the built-in Command Line tool, it lets you choose any level of involvement – from step-by-step processing to full automation. But even when you choose automatic one-click synchronization, you can still adjust the settings at any time to meet your needs. Besides, by automating the process, the tool eliminates mistakes or data loss that could occur if the process were done manually. 

SQL Data Examiner 2008 compares not only tables, but also views and SQL queries. The latest version allows you to update tables which are included into compared SQL queries, so now you can compare and synchronize virtually any data stored anywhere.

The data comparison tool allows any degree of developers involvement from step-by-step proceeding to full automation. The built-in Command line Comparison and Synchronization tool enables you to automatically perform any actions available in the GUI. But even if you choose the automatic one-click synchronization, you can still undo it at any moment to adjust the settings.

The tool compares the selected databases and displays the results of the comparison in a way that is convenient for you to review. It is a professional solution that simplifies the process of comparison and synchronization and saves time too. Try it yourself!

Major Features:

1. Comparison:
   • Microsoft SQL Server 7.0, 2000, 2005 and 2008 database comparison 
   • Comparison of data stored in Oracle databases 
   • Comparison of data stored in MySQL databases 
   • Comparison of data stored in MS Access databases 
   • Cross-platform data comparison (Pro only)   
     
   • Live databases as comparison source 
   • SQL Server detached database files and backups as comparison source (Pro only) 
   • Command Line Comparison and Synchronization tool (Pro only) 
     
   • Support for all data objects, including tables and views 
   • Comparison of SQL–query  (Pro only)   
     
   • Opportunity to update the results of SQL-queries (Pro only)     
   • Support for column mapping, additional filtering options (Pro only)   
     
   • Wide range of settings to cover your specific needs 
2. Synchronization:
   • "Smart" script-generating engine preventing a possible data loss 
   • Sophisticated script execution

• The new version added an opportunity not only to compare the results of SQL queries, but also to update them.
• Now any combinations of SQL Server, Oracle, MySQL and Access databases are possible to compare.
• Besides some minor improvements and bug fixes have been made.

Requirements:

• .Net Framework 2.0,
• MDAC 2.6