General discussion

  • Creator
    Topic
  • #2130311

    migrate from sql 7 to sql 2000

    Locked

    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)

All Comments

  • Author
    Replies
    • #3546280

      migrate from sql 7 to sql 2000

      by jmiller1 ·

      In reply to migrate from sql 7 to sql 2000

      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.

Viewing 0 reply threads