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 |
|
MediaPirate
Yak Posting Veteran
52 Posts |
 Posted - 2003-08-26 : 13:21:52
|
| Other than fixing by hand, is there any way to retain values and identities when DTS'ing from 1 SQL server to another? I know I could create a script to do it or continue to fix it by hand. I'm asking more in line of why it does this. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-08-26 : 13:35:28
|
| What is your DTS package doing? I don't know what you mean that DTS is dropping the identities and values. DTS will do whatever you tell it to do. Please explain further.Tara |
 |
|
|
MediaPirate
Yak Posting Veteran
52 Posts |
Posted - 2003-08-26 : 14:34:09
|
| It happens when you copy tables and views when using import/export wizard. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-08-26 : 17:31:36
|
| Do you mean that the table structure isn't the same? That's because it just creates the base table. If you want them to be the same, you'll need to generate the script, then create the table on the other server, then transfer the data.Tara |
|
|
|
|
|
|
DTS dropping Identities and values