April 30, 2002 at 2:21 am
Hello,
i have the following problem:
some of our productive systems work with SQL 2000 (others work with SQL 7.0), our test systems with SQL 7.0 (SP 1).
now we want to test some effects we have with one system on SQL 2000 with a productive system.
But the reimport to the test system does not work because server says he cannot use the file (despite the fact we said the 2000 server he should export the data for 7.0).
Many thanks
Matthias
April 30, 2002 at 5:33 am
Are you trying to detach/attach, or just move data?
Andy
April 30, 2002 at 5:35 am
Just move data
April 30, 2002 at 8:43 am
What file are you referring to then? Should be able to either BCP or DTS the data as long as the collations match.
Andy
April 30, 2002 at 9:15 am
Agree with Andy, use DTS to move the data only. You might have to mess with it to get the parent child data to go in the right order.
Steve Jones
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply