Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
reddymade
Posting Yak Master
165 Posts |
 Posted - 2008-07-30 : 09:55:22
|
| When i import table from one DB to another DB, i am losing the primary key fields Identity column settings.How can i import a table exactly the way it is in DB1.I am importing a table via tasks/ import data and then selecting DB&tableThank you very much for the information. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-30 : 09:59:59
|
| Have you looked into mappings and checked if you've set identity insert property to on? |
 |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2008-07-30 : 10:12:55
|
| And you then also have to edit the sql-statement to create the dest-table --> add identity(1,1) to the desired column.WebfredThere are 10 types of people in the world: Those who understand binary, and those who don't... |
|
|
|
|
|
|
Import table losing the identity column