General discussion


migrate from sql 7 to sql 2000

By tehan1 ·
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)

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

migrate from sql 7 to sql 2000

by jmiller1 In reply to migrate from sql 7 to sql ...

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.

Related Discussions

Related Forums