Easiest Way To Diff Two Table Schemas In SQL Server 2008?

Viewed 53807

I have to do checks between a development and release database and do this manually, which is both slow and not 100% reliable (I only visually inspect the tables).

Is there a quick and easy way to compare table schemas automatically? Maybe even a feature that does this built right into SQL server?

Edit: I'm comparing structure only, thank you for pointing this out.

10 Answers
Related