Results 1 to 9 of 9
  1. #1
    Join Date
    Nov 2003
    Posts
    39

    Question Unanswered: SQL Identity attribute drops when importing a table

    Hi all,

    I am importing SQL 2000 tables from a developer install of SQL 2000. There are no destination tables to append just new tables being brought in.

    I use the All Tasks > Import (DTS) service to do this. I have noticed that the Identity columns do not maintain the Identity attributes. I have to reset them after I import new tables. Is this normal? or is there a bug here?

    I checked the MS KB with no success.
    Anyone have some info on this?

    Thanks.

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Yeah, and you wont get any contraints or RI...

    Did you look at the transfer database task?
    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.

  3. #3
    Join Date
    Nov 2003
    Posts
    39
    Originally posted by Brett Kaiser
    Yeah, and you wont get any contraints or RI...

    Did you look at the transfer database task?
    Thanks for the relpy.
    I'll check it out.

    RM

  4. #4
    Join Date
    Feb 2002
    Posts
    2,232
    If you want to copy the entire database you can also use the copy database wizard, backup/restore, detach/attach ... Did you use copy tables or copy objects ?

  5. #5
    Join Date
    Nov 2003
    Posts
    39
    Originally posted by rnealejr
    If you want to copy the entire database you can also use the copy database wizard, backup/restore, detach/attach ... Did you use copy tables or copy objects ?
    Just copying tables with the wizard...

  6. #6
    Join Date
    Feb 2002
    Posts
    2,232
    Use copy objects.

  7. #7
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    I did not know that...very cool...

    still I'd think I'd rather script my objects and use bcp..

    MOO
    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.

  8. #8
    Join Date
    Feb 2002
    Posts
    2,232
    It does:

    Look in C:\Program Files\Microsoft SQL Server\80\Tools

  9. #9
    Join Date
    Nov 2003
    Posts
    39

    Smile

    Originally posted by rnealejr
    It does:

    Look in C:\Program Files\Microsoft SQL Server\80\Tools
    Thanks all! You have been most helpful!

    This is a great forum...glad I joined.

    RM

Posting Permissions

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