Click here to Skip to main content
13,298,965 members (41,570 online)
Click here to Skip to main content
Add your own
alternative version


15 bookmarked
Posted 16 Mar 2011

3 Kinds of Comparison and Snchronization for SQL Server Database

, 16 Mar 2011
Rate this:
Please Sign up or sign in to vote.
This article introduces you to 3 kinds of comparison and synchronization for SQL Server Database.


Today, I will introduce you to 3 kinds of comparison and synchronization for SQL Server database.

  • SqlDelta
  • Redgate SQL Compare
  • D-Softs Database Compare

Because of my work, I needed to develop and maintain the management software for three subsidiaries. The new procedures will be deployed in my company, so when the subsidiaries use the procedures, not only did I need to update the program, but I also needed to make sure the database structure is consistent with each one. Some basic data contents of table also needed to be consistent.

In the beginning, I did not know such software, I had to write log or script that the program be synchronized, it took too much time, and when synchronizing the date, there were all kinds of problems, such as bug of the script. Sometimes, it related to a dozen tables and stored procedures.

So I searched such software, and in my option, I chose three: SQL Delta, Redgate SQL compare, D-Softs Database Compare.

Normally, the function I need builds three comparative projects, sets the data objects which are needed to be compared, and when I need to do the comparison, after clicking to compare, I can browse the log and find out the difference, then click Sync, that's OK, it's easy.

Let's look at these software:

SQL Delta


D-Softs Database Compare


RedGate SQL Compare


These are the interfaces in building projects, the modes of operation are similar, links to information of source and target need to be provided.

It is worth mentioning that you can type the URL like,1433 directly, as this, you only need install a peanut hull for your fieldserver and open port of SQL Server? You can compare data directly through the Internet, as long as the network is not slow, the seep is very quick.

Let's look at that: how to select database objects and view the results of comparison.

Three software are all supporting tables, stored procedures, triggers, and so on, if you are sure there has been no change in stored procedures, you can ignore it, so that can up the speed.

D-Softs setting is more like SQL Server 2005.

The results of comparison are all display highlighting.

SQL Delta






Start to Sync: It's similar, they will compute the dependence relationship of database object, that means, the latter one is changed first. Otherwise if creating table which uses custom data types first, then builds the custom data types, it will not succeed.

SQL Delta






There are many other features such as data comparison and synchronization, and more detailed introduction. This time, I will not introduce all one by one.

And last, I will tell you that these software are not free. The prices are as follows:

  • RedGate is $395
  • SQL Delta is $330
  • D-Softs is $199

Although the prices are not cheap, the powerful features can offer convenience in our work.



  • 16th March, 2011: Initial version


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


About the Author

United States United States
No Biography provided

You may also be interested in...


Comments and Discussions

QuestionSQLDELTA software licensing server has issues Pin
Member 1053073626-Sep-16 20:32
memberMember 1053073626-Sep-16 20:32 
GeneralMy vote of 1 Pin
Jaspreet Singh Trehan28-Jun-11 6:42
memberJaspreet Singh Trehan28-Jun-11 6:42 
Generaloben dbdiff Pin
Yisman226-Mar-11 9:54
memberYisman226-Mar-11 9:54 
GeneralAnd one more Pin
Darron18-Mar-11 3:56
memberDarron18-Mar-11 3:56 
QuestionHow about VS 2010 free Sql Compare? Pin
sanme9817-Mar-11 16:24
membersanme9817-Mar-11 16:24 
Generalanother database comparer Pin
zSegundo17-Mar-11 9:06
memberzSegundo17-Mar-11 9:06 
GeneralI don't recommend RedGate Pin
Member 308248717-Mar-11 4:47
memberMember 308248717-Mar-11 4:47 
GeneralAnother one to consider Pin
vbfengshui16-Mar-11 9:00
membervbfengshui16-Mar-11 9:00 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Permalink | Advertise | Privacy | Terms of Use | Mobile
Web01 | 2.8.171207.1 | Last Updated 16 Mar 2011
Article Copyright 2011 by dingoishere
Everything else Copyright © CodeProject, 1999-2017
Layout: fixed | fluid