Primary Keys and Identity Settings Not Exporting

[jalbao]

I am using the Data Transformation Services in SQLServer 2K to export a database. I am basically attempting to copy/paste the database onto a different server.

Everything in the database is exported fine except primary keys and identity settings. Just to clarify, the field that is a primary key is exporting, but after it is exported it is no longer set as a primary key. the same is true with fields that are set to have Identity = Yes.

any clues?

 

[redlam]

In your DTS package, review the "copy options" in your task properties. uncheck the 'use default options' checkbox and click on the 'options' button. manually select all the options that you want to maintain in your export. you should be able to select/de-select primary key options in here.

 

[Bernadette]

HI There

I experienced this problem also using DTS and I discovered if you are transferring tables Check the "include dependant objects" checkbox as Primary Keys, Contrainsts and Identitys are objects which are dependant on the table.
This worked for me !

Hope this helps :-> Bernadette