Windows Forum

Ask something
Discussion Locked

migrate from sql 7 to sql 2000

0 helpful
1 reply

by tehan1

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Is anynoe able to explain how to migrate (not upgrade) from sql 7 to sql 2000? (As I understand there is a bit more to it than importing a backup up database)

1 reply

by jmiller1

It's not really that involved. You can either:

A. Backup the 7.0 database and restore it to the new server.

B. Detach the 7.0 database (sp_detach_db) and attach it to the 2000 server (sp_attach_db)

The only real consideration is making sure the logins for that database exist on the new server.

This discussion is closed to new replies.