>Hi all
>
>I wish to seek your advice on database compare tools that allows me to compare 2 MSSQL database and able to print difference report and generate TSSQL script to sync the database.
>
>Your advice is much appreciated
>
>Thanks & Best Regards

RedGate has a good compare tool.

Visual Studio 2010 Premium also has a good compare tool - that is what I use.

Both can generate scripts to sync structures (and data IIRC).