Import Export Wizard problem

[RajpootRohan]

Hi friends, I am stucked in a problem. I am trying export the data to the server through export import wizard. The data is going but the primary key and the auto-incrementation on a column was not transfered. I also tried through generating scripts but same results. And on the server there is no provision to restore through .bak file. So please assist me.

cheers, sneha

[Corporal Agarn]

I have used the method of scripting the table schema creating it in the receiving database and then do the copy. It will be interesting to see if there is a one step solution. Buy the way if you create using MS SQL 2000 you might need to tell it to script the keys. Good Luck djj

[Mycroft Holmes]

You are talking about 2 very different things, the data and a database constraint (primary key). Are you saying the primary key data is not exporting or that your scripting of the table does not include the primary key?

Never underestimate the power of human stupidity RAH

[Robin_Roy]

In the Import/Export Wizard make sure that you select the contstraints for data transfer.