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 |
|
cplusplus
Aged Yak Warrior
567 Posts |
 Posted - 2011-08-29 : 11:05:09
|
| How can i import a table from another DB, when i use teh import table feature in sql server from another db.The table is getting imported but the primary key, ID field is loosing the Identity.once after the successul table import if i open the table, i see the identity is lost.Now when i try to set the field as an identity column, at that time , it does'nt want to change.Is there a way to import the table object from another DN , to keep all properties intact?Thank you very much for the helpful info. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-08-29 : 11:09:27
|
| you've enable identity insert option inside export import wizard. you need to check that to preserve id values.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
How can i import a table from another DB