Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004
    Location
    Holland
    Posts
    18

    Lightbulb Unanswered: Question: Migration SQL Server (Databases) to another SQL Server.

    Hello ppl,

    Im curious whats the best way to migrate all SQL databases (with all users) to another server.

    Are there tools to do a migration like this or must I do it manual?

    Thanks for your time and answer.

    With kind regards,
    Pedro

    P.S. Its SQL 2000 on a Windows Server 2003 OS

  2. #2
    Join Date
    Jul 2004
    Location
    Inverurie
    Posts
    628
    if you have both boxes running, you could use DTS to migrate everything from one box to the other. (right click on a database and select export).

    not sure how this would work with the system databases though. It may cause some problems, and you may have to be in single user mode for it. You can transfer the user databases without any problems though.

  3. #3
    Join Date
    Apr 2004
    Location
    Holland
    Posts
    18
    ThX...I'm going to try it within 3 hours. I hope everything goes OK

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •