Comparing Tables of two databases in MS SqL server

I have two different databases on same   MS SQL Server 2000 machine how can i compare the tables and fields on these tables. Kindly suggest me if there is a software to compare the tables as well as the fields of the database.
LVL 32
Kamran ArshadIT AssociateAsked:
Who is Participating?
 
Aneesh RetnakaranDatabase AdministratorCommented:
These are Some tools

Red Gate -SQL Data Compare
AdeptSQL Diff
Best SoftTool -SQLDB Compare
0
 
auke_tCommented:
And both Redgate and AdeptSQL have free trial versions (non-crippled).

www.adeptsql.com
www.red-gate.com
0
 
Luan JubicaProject ManagerCommented:
You can take a look to:
www.apexsql.com

If you prefer to do it by your seft try to script the tables and compare the script with some text-file compare software which you can find a lot free.
0
 
sparabCommented:
sounds great
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.