SQL Examiner 2009 R2 3.1.0.39

SQL Examiner 2009 R2 3.1.0.39 is an important and beneficial tool that quickly and accurately compares and synchronizes schemas of MS SQL Server databases. It supports all the main innovations of SQL Server 2008, so now you can compare and synchronize databases of all SQL Server versions from 7.0 to 2008.

The tool provides support for different comparison sources, and runs equally well on a backup copy, a detached database or database snapshots. The list of schema objects it compares includes tables, stored procedures, views, user-defined functions, XML schema collections, CLR objects, database triggers, etc.

Major Features:

1. Comparision
   • Microsoft SQL Server 7.0, 2000, 2005 and 2008 database comparison   
   • Live databases and snapshots as comparison source  
   • Database creation script as comparison source    
   • Detached database files and backups as comparison source      
   • 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      
   • Wide range of settings to cover your specific needs    
2. Synchronization:
   • Partial synchronization    
   • "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

Requirements: Fully compatible with MS Windows Vista