dbForge Schema Compare for SQL Server Review

On the Dependencies wizard page you can see the grid with the objects that have not been explicitly selected for the synchronization, but which are used by objects, selected for the synchronization. dbForge Schema Compare lists the objects you need to include in the synchronization to avoid errors when executing the synchronization script.


Finally, a script will be generated. This script had roll back, error handling and transactions.

   Additional Features

Backup Compare : compare databases with native SQL Server backups. 

    

Snapshots : You can create snapshots of your database schema which can be compared at a later stage.

You can decrypt and compress this snapshot as well.

Integration with Version Control Software – This is another unique feature of dbForge where you have the opportunity of integrate with version controlling tools such as TFS and SVN.

The following link will list all features available in the dbForge tool.

http://www.devart.com/dbforge/sql/schemacompare/features.html

In this tool, you have a facility generate report for the discrepancies for the two compared databases.

 

As you can see in the above image, you have many options to generate comparison reports in either  HTML or Excel format.

Support is very essential when it comes to software tools and devart is providing adequate support from the mails and their sites. In addition, support is free for the user buying a product license

To summarise the features of DBChangeManager:

Pros

Generates Database Snapshots/SQL Scripts to version manage your Schema

Provides Database Synchronization Audit to track history of changes.

Ability to run this tool from command line options.

Integrate with Source controlling systems.

Ability to create backups before synchronizing database objects.

Cons

Inability to load synchronisation script to Query Analyser or SQL Server Management Studio from the application itself.

No option to create synchronise application.

Pages: 1 2




Related Articles :

  • No Related Articles Found

No comments yet... Be the first to leave a reply!

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |