Software

Ask something
Discussion Locked

move databases - sql 7 to sql 2000

0 helpful
2 replies

by mcgrath.b

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hello,

We are in a bit of a pickle. We have sql 7 running on a p2, 256mb ram, NT 4.0 server. The server is getting a tremendous amount of traffic each day so we need to upgrade to a better server (hardware). We are at a standstill as we are unable to us any of the methods posted here:

http://www.sqlteam.com/item.asp?ItemID=9465

We are unable do the deed via DTS on the new machine (we have tested with several). As well, we are unable to export any scripts. The backup is not working correctly either...

We are thinking that we have to build everything from scratch?

Any information or suggestions would be great!!
Thanks!

2 replies

by tony hopkinson

Can you see the sql7 server from the new one ?
sql7s backup is not working correctly, or you can't restore it on 2000 ?
Why can't you export scripts ?
Have you looked at using BCP, exporting to text and importing.

What about installing sql7 on a new box, moving the database across and then upgrading to 2000.

The procedure mentioned in the article could work in theory, but it's very fragile and in my opinion a last resort.

by mcgrath.b

thanks for the reply, but we are putting this process on hold for now. thanks for the input!

This discussion is closed to new replies.