DTS doubt

Discussion in 'Databases' started by KenA, May 27, 2004.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. KenA

    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
     
    KenA, May 27, 2004
    #1
  2. Bruce

    Bruce DiscountASP.NET Staff

    This really depends on how you setup the DTS package.

    Both #1 & #2 can be archieved


    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">
     
    Bruce, May 28, 2004
    #2
  3. KenA

    KenA

    Ok. Thanks for clarifying it :)

    »»» Ken.Awamura
     
    KenA, May 29, 2004
    #3
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page