SQL Server Performance

Migrate Databases

Discussion in 'SQL Server 2005 General DBA Questions' started by gus, Nov 15, 2004.

  1. gus New Member

    I have to migrate several databases from sql 2000 to yukon.

    What do you advise?
    Copy .mdf and re-attach it in yukon?
    Or is there another better way?

    Thanx.
  2. satya Moderator

    I would suggest to perform version upgrade rather than going direct route.

    Refer to the SQL server 2005 books online for complete information on performing this task.
    As SQL2k5 is still in beta it will good to know other features enlisted.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  3. gus New Member

    But I want to migrate just a couple of databases, not the complete server.

    I'll leave the "old" server running and wnat to do some testing in Yukon.
    The "old" server is the productive one and it will still be until finish testing with the new one.
  4. Luis Martin Moderator

    Backup and restore is a good option.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.

  5. satya Moderator

    Yes you can choose set of databases to upgrade as its possible in previous versions.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  6. mpex04 New Member

    I was able to completely unistall SQL 2000 and then install SQL 2005 and attach the databases without any issues. I did detach them before uninstalling 2000.

Share This Page