Post reply

Migrate SQL Server 2000 databases to SQL Server 2005

  • March 18, 2009 at 4:39 pm

    #207152

    Hi,

    I need to migrate SQL Server 2000 databases to SQL Server 2005 as a whole. I want an automated approach only! (I did it manually already)

    What is the best approach to be taken?

    Thanks,

    Sriram

  • March 18, 2009 at 6:02 pm

    #962373

    Restore your 2000 backup file on 2005, it would be upgraded automatically.

  • March 18, 2009 at 9:23 pm

    #962456

    I wanted something like a Script or a Job or a Wizard.

    I just now tried "Copy Database Wizard..." to automate/schedule the process of migrating SQL 2000 DBs to SQL 2005 but it was erroring out without any specific description for error.

    Please let me know how I can proceed.

  • March 18, 2009 at 9:39 pm

    #962459

    Nothing will be simpler than backup and restore, especially for large databases.

    It can be scripted, and scheduled in a job.

  • March 20, 2009 at 4:25 am

    #963406

    I agree. Backup and restore is simple, reliable, and effective.

    If you want to automate things you have to write your own script, but this is not a difficult task.

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

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

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