Hi,
I would like to compare two sql server databases.
I need to find the difference in the two database(i.e table, colums,
data type)
Is there any free utility available to compare sql server database
I'm using sql server 2000.
Help me out to compare databases

Thanks & Regards,
Mani

It's not free, but you can download a 14-day trial version;
http://www.redgate.com/products/SQL_Compare/index.htm

Markus

Another one is AlfaAlfa's SQL Server Comparison Tool (SCT)

http://www.sql-server-tool.com

- also not free, but it has 30 days of free evaluation period, which
can be extended to 90 days. Comparisons can be fully automated
through the usage of command line parameters.

SCT works with SQL Server 2005, 2000 and 7.0 and between these
versions.


Dariusz Dziewialtowski.