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 |
|
Hommer
Aged Yak Warrior
808 Posts |
 Posted - 2004-09-29 : 12:48:33
|
I have seen this one many times. It got to be a bug. Did I miss any patch that could have fixed it?Here is the situation. I am running SQL Server 2000 Standard. I used DTS to copy table structure from one instance to another. I checked off those I want to copy. The DTS run. It copied the ones I want AS WELL AS some of others that I did not select. And because I chose not to copy data, these other tables’ data got wiped out.Don’t you hate situation like this? It made you guilty.  |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-09-29 : 18:17:29
|
| I've never seen this before and have never heard of a bug like this either.Why are you using DTS for this? To move data from instance to another, why not just use INSERT INTO SELECT * FROM?Tara |
 |
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2004-09-30 : 11:36:35
|
| No, I am not moving data. I want to save the table structures, including relationships, indexes, and others. There are about hundred of them.My temporaly solution is to manually delete those tables (also in the numbers of hundred) that I don't want to keep, then run the DTS since the select-and-copy is not able to realy selectively copy.The other alternative I can think of is to script each table then save in a bid .sql. That will take more work. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-09-30 : 12:23:54
|
| To move table structures only, just use the Generate SQL Script wizard to script the DROP and CREATE statements for your tables. Then run that file on the destination server.Tara |
|
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2004-09-30 : 13:24:38
|
| Ok, I will try and compare the results.Thanks, Tara! |
|
|
|
|
|
|
DTS copy object BUG