Devart Blog

Backup Comparison and Database Versioning Added in Schema Compare for SQL Server 2.00

Posted by on January 29th, 2010


Schema Compare for SQL Server 2.00 compares schema snapshots, database backups, and database changes in version control systems to accelerate the work of advanced database developers.

Devart today announced the public availability of  Schema Compare for SQL Server 2.00 that delivers new capabilities to help customers more effectively compare databases and more quickly migrate schema changes across different SQL Server versions.

Featuring new functionality, the tool is better equipped to span a full spectrum of database comparison and synchronization tasks and allows completing them at a professional level.

The highlights of Schema Compare for SQL Server 2.00 include:


  • Support of native SQL Server backups. The users can use native SQL Server backups as a metadata source
    and compare them. It adds a new way to compare and update database structures without manual work.
  • Database comparison and synchronization via command line. This is especially useful for the users, who do repeated schema comparison and synchronization. It is enough to set a comparison once
    and the tool will prepare a file with required command line arguments – Source and Target
    connection strings, comparison options and settings. The users can schedule the launch time
    for the processes specified in the file and escape any waiting.
  • Tracking database changes using version control systems. This prevents several developers from changing database objects simultaneously. Now it is easy to revert
    to earlier revisions and quickly identify who and when changed the objects. Comparison takes
    less time as schema snapshots are compared. dbForge Schema Compare uses two most popular version
    control systems — SVN and TFS.
  • Generating comparison and synchronization reports. Now publishing differences between databases is automated and offered as clear and professionally looking reports.
  • Synchronization of database properties. A database will be synchronized as an object and you will see what changes have been made to the database.
  • Character-oriented comparison. Even a single different character is highlighted in the text compare to save the user’s time and efforts.
  • Standard and Professional product editions available. You can select only required SQL  tools and save your money.

Check the benefits yourself, download dbForge Schema Compare for SQL Server 2.00 now for free.

Tell us what you think about the new version at the product feedback page. We are looking forward to your comments and suggestions.

Leave a Reply