Migration from SQL 7

  • We are preparing for some major upgrades in my company. Moving from NT 4 / SQL Server 7.........to Server 2003 / SQL Server 2005.

    I want to begin preparing, but cannot find anything on migrating from 7 to 2k5. Only 2k to 2k5.

    Would appreciate it if anyone could point me in the right direction.

     

    Thanks

  • This was removed by the editor as SPAM

  • I'll try to answer any questions that I can.  What type of data are you looking for in terms of migration?  One thing I can tell you about your platform combination is that SQL 2005 requires Win2k SP4 or higher to install on, so you will not be able to do an in-place upgrade by running setup on those machines and having the installation let you pick the SQL7 instance to be upgraded. 

    Moving from NT 4 / SQL Server 7.........to Server 2003 / SQL Server 2005.

    Options are:

    1. Upgrading the OS from NT4 to W2KSP4, then you'd be able to upgrade in place with the setup wizard
    2. backup/restore
    3. detach/attach

    For 2 and 3 to happen, you'd still need to install a SQL Server 2005 instance on a box running one of the supported Operating Systems (Win2k SP4, XPSP2, or Win2003), and then you'd be able to restore or attach the data files, and then you'd probably have to script out your logins and other data contained in your system databases.

    Does this help a bit?

    Thx, Niko

    SQL Setup Test Team

    --
    Thx, Niko
    SQL Setup Test Team

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

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