Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I am looking for a free software that can:

  1. Compare two MS Sql Server databases (Both schema & data)
  2. Also provide a method to synchronize the databases.
share|improve this question

migrated from superuser.com Apr 5 '11 at 14:33

This question came from our site for computer enthusiasts and power users.

    
How do you mean by "synchronize" ? –  Sathya Oct 4 '10 at 14:01
    
It should be able to transfer diff data between the databases compared. –  goths Oct 4 '10 at 14:40
1  
Not free, but if you using Visual Studio 2008 or 2010 the Database Projects which is part of Premium and higher does this for you. –  Diago Oct 4 '10 at 15:19

4 Answers 4

Red Gate SQL Compare has a 14 day free trial and it's pretty good. http://www.red-gate.com/products/SQL_Compare/

share|improve this answer

OpenDBDiff is an open source project up on codeplex that purports to do this. It seems pretty stable, but I have not tried it.

share|improve this answer

Atlantis Schema Inspector was recently made free, and does this task. Also, the source code to the sync API was recently open sourced if you are interested in writing a custom solution from PowerShell or C#.

share|improve this answer

I have not used this product directly (I am using the MySQL variant all the time) - but Toad for SQL Server may fit your bill.

Altough I think it is not free for SQL Server.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.