I was just told by a friend that I need to check out what he called “Data Dude”, which is an add-on for Visual Studio 2008.
It adds a Database Schema compare so that you can compare two different databases. I ran it on our beta db and dev db, and found several differences that I didn’t expect.
Everything from triggers, indexes, columns, etc.
It’ll let you drill down into the dependencies, allow you to make the updates, or create new items, etc:
You can easily see the differences:
Here’s the Link: