SQL Examiner 2008 R2 2.2.0.22

SQL Examiner 2008 R2 2.2.0.22 is a database comparison application designed for quickly and accurately comparing and synchronizing schemas of SQL Server databases, including stored in SQL Server 2008. It allows you to decide what changes are to be synchronized. You can also synchronize even separate columns or constraints with the partial synchronization mode.

The tool’s flexibility allows you to be as involved as you want in the development process, from step-by-step processing to full automation. Due to the built-in Command Line tool, you can choose automatic, one-click synchronization and focus on the main - design and development. SQL Examiner handles all the routine work itself.

SQL Examiner 2008 provides support of different comparison sources, and runs equally well on a backup copy, a detached database or database snapshots. The new version enables you to compare with SQL scripts. The list of schema objects which it compares includes tables, views, stored procedures, user-defined functions, XML schema collections, CLR objects, database triggers, etc.

SQL Examiner 2008 handles all the routine work itself and enables you to focus on the main design and developments. You can choose any level of involvement from step-by-step synchronization to full automation and use the built-in Command Line Comparison and Synchronization Tool to automatically run your day-to-day procedures.

SQL Examiner 2008 merges two selected databases with just a few clicks. It generates a script that takes the dependencies between the objects and your data into account and delivers precise results. Get SQL Examiner 2008 now and enjoy the guaranteed high-quality results.

Major Features:

1. Comparison:    
   • Microsoft SQL Server 7.0, 2000, 2005 and 2008 database comparison   
     
   • Live databases and snapshots as comparison source   
   • Database creation script as comparison source (Pro only)
     
   • Detached database files and backups as comparison source (Pro only)
   • Command Line Comparison and Synchronization tool 
     
   • Support for all schema objects, including tables, views, stored procedures, etc  
   • Support for SQL Server CLR objects, including assemblies, stored procedures, triggers, UDTs, UDFs  
   • Extended comparison options  
   • Support for column renaming (Pro only)  
     
   • Wide range of settings to cover your specific needs  
2. Synchronization:
   • Partial synchronization learn more  
   • "Smart" script-generating engine preventing a possible data loss  
   • Taking data in the target database into account  
   • Tracing links between objects within a schema  
   • Sophisticated script execution

• The new version added an opportunity to compare and synchronize SQL Server databases with SQL scripts.
  
• Besides some minor improvements and bug fixes have been made.
  

Requirements:

• .Net Framework 2.0,
• MDAC 2.6