1

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

2 Answers 2

6

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.

1

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

You must log in to answer this question.