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.

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. 


Pages: 1 2


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 |