Sql Server Comparison Tool and Sql Examiner Suite 2008 Software for Windows

Sync For SQLServer
$199 - SleepyAnt Software

Sync For SQLServer is designed for software developers or database administrators who are working with the Microsoft SQL Server database. It compares two SQL Server databases and determines the differences between them. It generates a SQL change script to convert the database architecture with its tables, relationships, stored procedures, functions, ... AND DATA into the desired target database. The existing data in the target database remains completely intact.

This is an invaluable tool if you are going through rapid development and release cycles that require extensive modifications to the architecture of the database. You can save hours of work to keep your databases in synch.

Sync For SQLServer has a visual and easy-to-use interface both at the stage of selecting the databases to be compared and to view the comparison results. The software has a lot of options for comparing all relevant objects. The resulting change script can be edited with support of SQL syntax highlighting.

One of Sync For SQLServer unique features include the data migration from the source database to the destination database. Other tools don't offer this feature in one product, which is integrated with Sync For SQLServer. You can migrate the data in a lot of ways to get your data to the destination database where it is exactly wanted.

Sync For SQLServer is based on the Microsoft .NET framework. The very easy to use and intuitive graphical user interface applies the MS Office 2005 style.

---

---

AdeptSQL Diff
$240 - Adept SQL Tools

AdeptSQL Diff is a lightning fast and intuitive tool to visually compare and synchronize two MS SQL Server databases. The program scans both databases and displays the schema tree view, with all differences color-marked. Navigating through the tree, you can see SQL definitions for individual objects (tables, view, stored procedures, etc) compared side-by-side and produce difference scripts for any choosen part or for the whole schema. The program lets you execute the generated scripts either uninterrupted or step-by-step, set breakpoints, turn on transactions and rollback on errors. A unique schema matching engine generates the minimal non-destructive SQL for any schema changes you you need to synchronize, keeping your data safe. Starting with version 1.50, the program also includes DataDiff - a data comparison and synchronization module. The current version supports MS SQL Server 7, 2000 and 2005.

---

---

SQL Examiner Suite 2008
$299.95 - TulaSoft, LLC

SQL Examiner Suite 2008 is a quick and easy-to-use software solution that enables you to compare and synchronize both schema and data. It covers all your SQL database comparison and synchronization needs, and fulfills any task on merging databases with just several clicks of a mouse.

SQL Examiner Suite 2008 is a complete database comparison solution. It includes SQL Examiner 2008 and SQL Data Examiner 2008, so in one program product you get two comprehensive tools that complement one another, and thus receive an opportunity to use the advantages of each of them.

The suite provides support for all main innovations of SQL Server 2008, so now you can work with all SQL Server version from 7.0 to 2008, and run cross-version comparison, when one of the compared databases is on SQL Server 2005, for example, and the other is on SQL Server 2005.

SQL Examiner Suite 2008 supports Oracle and MS Access as well, and allows cross-platform data comparison. Besides, it is able to use different comparison sources, and equally well runs on a backup copy, a detached database or database snapshots. With the suite you can compare all data objects, including tables, views and SQL?query. And the list of the schema objects it compares includes tables, stored procedures, views, user-defined functions, XML schema collections, CLR objects, database triggers, etc.

Due to its flexibility you can be as involved in the comparison process as you want. You can choose step-by-step or automatic synchronization, so the built-in Command Line Comparison and Synchronization Tool allows you to automatically perform any actions available in the GUI. But even if you choose the automatic ?one-click? synchronization, you can undo it any moment to adjust the settings.

SQL Examiner Suite 2008 is a solution that works for the profit of your business. Now you can forget about routine manual work and focus on design and development, as the suite will handle all the tedious manual work itself.

---

SQL Effects Clarity
$139 - SQL Effects Software

SQL Effects Clarity is an advanced SQL Server database comparison tool. The tool differentiates itself from other database comparison tools by focusing on ease of use, flexible comparison selections and criteria, lightning fast comparison performance, unique GUI review of differences (instead of scripting out the objects then doing a basic file compare - a common method in other tools), and also offers multiple results analysis and review and reporting and export methods.

SQL Effects Clarity is a software tool made for software professionals by active software engineers who have to do on a daily basis the kinds of chores the tool is designed for:

Verifying change scripts.
Identifying undesirable changes in a database environment - or verifying that there aren't any.
Ensuring that your production environment is the same as your test and development environment.
Diagnosing those odd situations where a problem happens in production - but can't be reproduced in your development environment.
Understanding the database differences between two different releases.
Code reviewing recent changes in stored procedures, SQL functions, views and triggers with an easy way to see line by line diffs.

---

SQL Data Examiner 2008
$199.95 - TulaSoft, LLC

SQL Data Examiner 2008 compares and synchronizes data of Microsoft SQL Server databases. It is an easy-to-use tool that makes any data migration process a few clicks operation. The tool handles the routine manual tasks itself and thus simplifies your work as a DBA or a developer. It saves you precious time and enables you to avoid tedious manual work.

The tool provides support for all main innovations introduced in MS SQL Server 2008, so now you can work with all SQL Server versions from 7.0 to 2008. Besides, it supports Oracle and MS Access and allows the cross-platform comparison, when the databases you compare are stored in servers of different types.

SQL Data Examiner 2008 compares not only tables, but also views and SQL?query. The latest version of the tool supports column mapping as well, and has additional filtering options.

The data comparison tool enables any degree of the developer?s 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 any moment to adjust the settings.

The tool compares the selected databases and displays the results of the comparison in a way it could be 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!

---

SwisSQL - DBChangeManager
$295 - AdventNet

SwisSQL DBChangeManager is an affordable and easy-to-use tool for Comparison and Synchronization of Microsoft SQL Server database schema. It also offers powerful Reporting, Auditing and a Web based client interface which makes it the best fit for collaborative database development and database change management. It also offers a Free Edition with some feature restrictions and no expiry limitations.

Key Benefits

* Save Time and Effort on Comparison and Synchronization
* Reliable and Error-free Synchronization
* Audit database changes effectively
* Complete change control with centralized administration and monitoring
* Instant Familiarity with intuitive and easy to use, Web based GUI
* Web based Access from any machine and anywhere (LAN, VPN..)
* Multi-user access promoting closer collaboration
* Affordable cost

SwisSQL DBChangeManager Features

1. Compares and Synchronizes all object types of Microsoft SQL Server 2000 and 2005 database schema.
2. Supports comparison of Database Schema from Live Databases, SQL Scripts stored in version control systems or Database Snapshots generated by the tool itself.
3. Generates accurate and optimized transaction based SQL scripts for synchronization. Also ensures clean rollbacks on synchronization failures.
4. Handles object dependencies and referential integrity during database comparison and synchronization.
5. Generates Database Snapshots/SQL Scripts to version manage your Schema.
6. Provides Database Synchronization Audit to track history of changes.
7. Web based client interface makes the tool accessible from anywhere through a Web Browser.
8. Multi-User access enables collaborative use of the tool alleviating multiple installation/upgrade overheads.
9. Comprehensive HTML reports on Schema Comparison and Audit history makes change tracking/auditing possible offline.
10. Supported on both Windows and Linux platforms.
11. Command Line Utility for command line execution and Scheduling with E-Mail notification capability

---