Post reply

Side-by-side upgrade from SQL 7 SP3 to SQL 2005

  • June 12, 2006 at 10:54 am

    #168564

    Has anyone encountered any issues with taking databases from SQL 7 SP3 to SQL 2005?  (backup DBs from SQL 7, restore DBs to SQL 2005)

    I understand that the Upgrade Advisor states that you must be at SQL 7 SP4 to upgrade but I believe that only applies to an "in-place upgrade" where you are actually upgrading to SQL 2005 compatibility and not migrating/moving (keeping SQL 7 compatibility).

  • June 15, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • June 17, 2006 at 11:54 pm

    #644488

    Here are some quick thoughts.  If by side by side, you mean installing SQL Server 2005 as a separate named instance on the same machine then I suspect that should work as it is not a true upgrade.  Once that is done you should be able to copy the databases from one instance to the other.   Secondly you may be able to back up the databases and restore them on the 2005 instance.  My experiece in that this also upgrades them to 2005 databases.

    Keep in mind that SQL Server 7.0 did not allow Named Instances while 2000 and 2005 do.  To have side by side installation the 2005 Server has to be a named instance.  If you list it as a default, either the upgrade will fail or your 7.0 server will be wiped out. 

    Always backup your database prior to implementing this type of task.

    Scripts, and functionality that would have been lost with the SP3 to SP4 compatibility will still probably get lost, but I believe the overall process should work.

    If you go that route let me know the result.

    Thanks,

    Keith

  • June 21, 2006 at 10:31 am

    #645083

    I am actually working on the same project with side-by-side 7 to 2005. Believe me, you have to have SP4 and all DBs need to be in 70 compatiblity mode.

    Here is what you have to do:

    1 - Make sure that 7.0 server is at SP4

    2 - Make sure that all databases are in 70 compatiblity level

    3 - Make sure that 7.0 Ids have strong password otherwise migrating them will failed because passwd policy is enabled by default on 2005.

    4 - Install Integration Services otherwise you will not be able to create maintenance plan.

    Any other questions let me know gnofodji@netscape.net

     

    Good luck.

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

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