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 |
|
coolerbob
Aged Yak Warrior
841 Posts |
 Posted - 2006-03-16 : 12:21:13
|
| I have two identical databases. One on 2005 and one on 2000. As a one-off, I want to move the data from 2005 to 2000. Obviously backup/restore & detach/attach are out of the question (as all software isnt forwards compatible - including sql2000).So I think my fastest alternative is a bcp/bulk insert for each of the 80 tables.Anyone got a better idea? |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-03-16 : 12:37:49
|
| or maybe use the new integration services to move the data. |
 |
|
|
coolerbob
Aged Yak Warrior
841 Posts |
Posted - 2006-03-17 : 08:13:13
|
| i tried ,but I'm not to switched on with that yet. things have changed quite a bit |
|
|
|
|
|
|
2005 --> 2000