Post reply

DTS question

  • July 20, 2005 at 2:23 pm

    #86863

    Hi all,

    Is this normal that when you create a table through DTS from one SQL server to another SQL server, the PK and Identity property do not get created?

     

    The table does not exist on the destination, you click CREATE, but if the Source has PK or Identity on the column, these properties are NOT created on the Source.

     

    Thanks

  • July 20, 2005 at 3:22 pm

    #575928

    If are creating it through the wizard or the data pump task, yes that is normal behavior.  If you want to copy a table with the PK and Identity properties, use the Copy Objects Task.

    Diane

  • July 21, 2005 at 7:26 am

    #576059

    Thanks DM

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply