How to compare the structure of two MS SQL databases? [closed]

Question

I need a free tool or some kind of tip/technique to compare the structure of two Microsoft SQL databases. Preferably MS SQL 2005.

The technique I tried to make work was generating scripts from both databases and then comparing the two files, but SQL Server generates objects in random order.

Answer 1

it's only free on trial for 14 days, but redgate sql compare is pretty good and easy to use.

Answer 2

I use this tool: http://www.codeplex.com/ScriptDB on my dev database.

Then I check all the files into svn and diff the files generated to see what needs to be changed in my live database. Works for me.