[Solved] Checking referential integrity and other constrains on two server

See more:

SQL-Server-2005

SQL-Server

I have two server . between which i need to check referential integrity and other constraint.

Like the below example.It will surely descibe the condition and issue.

There is two server SERVER1 and SERVER2.
SERVER1 having Database DB1
and SERVER2 having Database DB2

DB1 having table TABLE1 (ID Bigint Indentiry (1,1),CreateDate datetime DefaultValue GETDATE())

DB2 having same table TABLE1(ID Bigint ,CreateDate datetime)


Also there are many forieng keys present in DB1 but not in DB2.

Please suggest me to find out what keys and constraints are missing in DB2 and also if there is any way to script out all the missing component. so that i ran that scripts on DB2.