sql server: losing identity column on export/import
Posted
by
Y.G.J
on Server Fault
See other posts from Server Fault
or by Y.G.J
Published on 2011-08-28T18:23:10Z
Indexed on
2012/07/08
15:17 UTC
Read the original article
Hit count: 183
sql-server-2008
Recently I started dealing with SQL Server, my previous experience was in MS-Access.
When I'm doing an import/export of a db, from the server to my computer or even in the server, all column with primary key loose the key. Identity is set to false and even bit is not set to the default.
How can I can I use an import/export job to make an exact copy of the db and its data? I don't want to have to perform a backup and restore every time I want the same db somewhere else, for another project, etc.
I have read about "edit mapping" and the checkbox but that did not helped with the identity specification... and what about the primary key of the tables and the rest of the things?
© Server Fault or respective owner
