DTS doubt

[KenA]

Hi. Suppose I have an SqlServer DB and some tables in it. Table A and Table B and some Relationship between A and B. Suppose I have those tables filled with some data in.

Well, in case I use DTS to transfer my local DB to the remote DB. Once the DB was transfered:

1. Will the Relationships between A and B be preserved?

2. Will the table´s data be transfered?

»»» Ken.Awamura

[bruce]

This really depends on how you setup the DTS package.

Both #1 & #2 can be archieved


[b]quote:Originally posted by KenA

Hi. Suppose I have an SqlServer DB and some tables in it. Table A and Table B and some Relationship between A and B. Suppose I have those tables filled with some data in.

Well, in case I use DTS to transfer my local DB to the remote DB. Once the DB was transfered:

1. Will the Relationships between A and B be preserved?

2. Will the table´s data be transfered?

»»» Ken.Awamura
</blockquote id="quote"></font id="quote">

[KenA]

Ok. Thanks for clarifying it :-)

»»» Ken.Awamura