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 |
|
BCogdill
Starting Member
2 Posts |
 Posted - 2007-10-01 : 11:12:49
|
| Hello,I'm fairly new to MS SQL & I have a problem copying tables from one d/b to another. When I do an import or export select Copy tables, the tables & the data get transferred, but all the Identities are set to NO. My D/Bs have 188 tables & it's a pain to reset all of them manually. Is there a setting I don't know about that will transfer the tables & maintain the Identity?(I'm using SQL Server Management Studio 9.0)Thanks for your help - Breck Cogdill |
|
|
tpiazza55
Posting Yak Master
162 Posts |
Posted - 2007-10-01 : 11:18:35
|
| backup and restore -- everythiung goes that way |
 |
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-10-01 : 11:33:46
|
You have to edit the mappings and enable identity insert. I have read about bugs though in this area, I will look into more specifics and let you know what I find out.
Future guru in the making. |
|
|
|
BCogdill
Starting Member
2 Posts |
Posted - 2007-10-01 : 11:58:36
|
quote:
Originally posted by Zoroaster
You have to edit the mappings and enable identity insert. I have read about bugs though in this area, I will look into more specifics and let you know what I find out.
Future guru in the making.
Thank you for your help . . . If you do find a solution, I really appreciate helping me with this.I have tried checking the Enable Identity Insert box, but it still doesn't work.Breck Cogdill |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-01 : 21:56:05
|
| Tried with transfer db objects in ssis? Should be able to copy extended properties that way. |
|
|
|
|
|
|
Importing/Exporting Tables - Losing Identity