Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.


UPDATE: I am not looking for any mirroring solution etc. Not a server solution. Just a simple desktop app that can show be a differences between two sql server databases and generate some script to make the schema/db in sync.

share|improve this question
Please provide more information, otherwise you get useless answers such as mirroring. Did you look into replication? – TomTom Oct 4 '10 at 14:10
When I saw the question in the unanswered list, I immediately thought "why don't they use log shipping or mirroring?" More info is definitely needed like TomTom said, for all anyone knows, either of those could be viable solutions depending on what is needed... although I have a feeling ozamora is on the right track here. – tcnolan Oct 13 '10 at 16:05

To sync up data, that is a tough find if you dont wan to pay. OpenDBDiff can do schema for free

share|improve this answer

Your Answer


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.