0
Answer

Identity and primary key lost during import in sql 2008

gopal kannan

gopal kannan

11y
1k
1
hi..

in sql server 2008 i used to import my database to another server with values and all my constraints loss using import database option.

but after importing i noticed, my destination database does not contain any constraints like primary key and identity set.

how to handle this issue.

need ur suggestions with examples.

Note:
  i need to restore the d/b via import/export and some other option only.
i dont have  remote server direct access for restoring the database.


regards
gopal.s