The SQL Compare application will allow you to compare the structure of two SQL server databases and display all the differences between them. You can compare databases online or you can take snapshots of the structure of the databases and compare them off-line, which is ideal for when you have a regularly updated database and want to check if the all the changes to the database were committed successfully.