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

Can someone please advise me on the below.

I have 2 databases, both of then were identical until few years back when we started to add more tables, procedures, views triggers etc to one of the database. Now i have to copy all the changes made in database 1 to database 2.

Please, can someone throw some pointers or links which can guide me to accomplish the above

Massive thanks in advance

Cheers Amit

share|improve this question

migrated from Oct 20 '10 at 23:46

This question came from our site for professional and enthusiast programmers.

Check out Red Gate's SQL Compare - and FYI there's also Data Compare that will synchronise data too. There are trial versions you can try out.

share|improve this answer

Try to use SQL Examiner Suite. I'm using this tool for a while and I love it.

share|improve this answer

Your Answer


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