|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Export/Import Tables w/ Primary Key
Can someone tell me if there's a way to export data from one database to another without losing the primary key information that has been set in the source database?
Please respond to URL. Thanks! CC |
|
#2
|
|||
|
|||
|
You can use Data Transformation Services (DTS) in the SQL Server Enterprise Manager to export tables. In the DTS package options there is an option to preserve the existing primary key values.
|
![]() |
| Viewing: Dev Shed Forums > Databases > MS SQL Development > Export/Import Tables w/ Primary Key |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|