Copy schema and data changes from one SQL Server DB to another

Hello Experts,

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

From serverfault $pageUsers[$entry.posts[0].author].name

• 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.

  From $pageUsers[$post.author].name

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

  From $pageUsers[$post.author].name