Transfer Table Relationships

microsoft.public.sqlserver.programming

2 Dec 2005 8:27 PM

Mike Moore

How can I transfer DB diagrams and referential integrity relationships
between databases with the same structure. I copied dtproperties table
from one DB to another but it copies diagrams without foreign keys.

3 Dec 2005 9:39 PM

John Bell

Hi Mike

Have you checked the the FKs are there?

If the remote database was create with the copy table options in the export
wizard then it tends to drop PKs/FKs/Indexes... The copy objects option
should retain them.

If you want an exact copy of the database you may want to use backup/restore
instead although this will also copy the data.

John

Show quote

"Mike Moore" wrote:

> How can I transfer DB diagrams and referential integrity relationships
> between databases with the same structure. I copied dtproperties table
> from one DB to another but it copies diagrams without foreign keys.
>