Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2004
    Location
    NC
    Posts
    13

    Unanswered: Proprties not imported with Table

    I am developing a DB with others in my group. When I import tables created on other servers to my server, the primary key and other properties do not import with the tables. Can anyone explain why this is happening? Is there a setting I have over looked?

  2. #2
    Join Date
    Sep 2003
    Location
    Dallas, Texas
    Posts
    311

    Re: Proprties not imported with Table

    If you use DTS, make usre you use the Copy object(s) instead of Copy table(s) option.

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Nope...what method are you using to migrate the Data

    Look at DTS transfer Database Task option

    Or better yet, script the objects then build them...I prefer this method, and use bcp
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  4. #4
    Join Date
    Mar 2004
    Location
    NC
    Posts
    13

    Re: Proprties not imported with Table

    Originally posted by joejcheng
    If you use DTS, make usre you use the Copy object(s) instead of Copy table(s) option.
    The copy object worked ... Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •