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.

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 stackoverflow.com Oct 20 '10 at 23:46

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

2 Answers 2

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

 
discard

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