dbForge Schema Compare for SQL Server Review

Product: dbForge Schema

Publisher: Devart




30 Day Trial



 From 149.95$


 From 229.95$

Standard edition includes essential tools for schema comparison and synchronization.

Professional is a fully-featured tool, able to complete any schema comparison and synchronization tasks.

Hardware Requirements




800 MHz or Higher


512 MB

Disk Space

30 MB


Microsoft Windows XP/2003/Vista and Windows 7


.NET Framework 2.0 SP1, 3.0, or 3.5 installed.


Devart has released a comparison tool which supports SQL Server developers and DBAs to support their day to day work.  


The key use of this tool is to compare database schemas between databases.  

First you need to define the source and   target databases. In this, you can create a connection which can be used later.

You can ignore unnecessary options such as constraints, indexes column order etc as shown in following image.

In the above dialog box, all the available options are clearly elaborated so that any developer can understand.  Also, you have the option of saving your defaults by using the Save As My Defaults button. When you are performing another comparison, you can recall these  by clicking the My Defaults command button.

Next, you have the option of filtering objects so that you can filter unnecessary objects to narrow down the comparison.

In addition, there is another tab to map schemas. Sometimes, different databases have different schemas but the same objects. To match this, you can Schema mapping tab.

Finally, the most important comparison will be shown:

Output will have four categories, Only in Source, Different, Only in Target and Equal.  

Most tools does not support trigger order  which is  supported in this tool.


In a comparison tool, synchronizing is very important.  Synchronization runs through a wizard.

In the first option of the wizard there are three options as shown in the following image.

Although, you can save them in a sql file, there is no option to open your favorite external tool, like SQL Server Management Studio. (SSMS).

The next tab allows you to take a backup of your target database. This is a rare feature among compare tools.

Next tab is to script dependencies if required. 


Leave a comment

Your email address will not be published.