Transfer table Relationships

#1

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.

#2

Hello Mike,

dtProperties has nothing to do with relationships.

Can you use the TRansfer objects task to move the relationships? Remember
this will only be SQL Server to SQL Server

Allan

Quote:

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Transfer table Relationships

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Transfer table Relationships - 12-02-2005 , 02:28 PM

Re: Transfer table Relationships - 12-02-2005 , 04:32 PM