Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm trying to move a MS SQL database from one provider to another, but attributes such as auto_increment for primary keys aren't copying over. I have MS SQL Server Management Studio 2008 installed, but I don't see any options to copy this properties over in the Import and Export wizard. Can anyone explain how this is done? I'm not a Windows person at all.

share|improve this question

If you are moving the database from one Microsoft SQL Server to another, you are better served by either using the "Copy Database..." wizard, or by taking a backup of the database and restoring it to the other server. The Export/Import wizards are for moving data to/from other database systems.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.