>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).
____________________________________
Don't Tread on Me
Overthrow the federal government NOW!
____________________________________