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 update database and want to check if the all the changes to the database were committed successfully. After comparing you will be allowed to save the results of the comparison to an HTML file.