• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1524
  • Last Modified:

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.
0
Kamran Arshad
Asked:
Kamran Arshad
3 Solutions
 
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
 
luaniCommented:
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

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now