Post reply

Database Migration from 2000 to 2005

  • February 12, 2009 at 6:54 am

    #206500

    Hi all,

    I want to upgrade database in 2000 to 2005 :).it could be helpfull if anyone could tell me various options to upgrade. 😉

  • February 12, 2009 at 6:56 am

    #942805

    Either Detach the database from 2000 and then re-attach to the 2005 system, and make sure you copy the logins over

    Or if you can not afford any down-time then restore a backup from the 2000 to 2005.

  • February 12, 2009 at 7:29 am

    #942847

    any other options?????what about copy database wizard 🙂

  • February 12, 2009 at 7:36 am

    #942852

    steveb's suggestion is the best, bar none. copy database wizard is not reliable compared to the built in ability of a SQL 2005 server to update an existing 2000 MDF or restore a database to the 2005 version.

    any other solution would not be a"best practice" ...yuo could script out every table and it's data as TSQL, but is that easier or faster than using the built in and faster tools?

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply