Post reply

migrating sql server 2005 to 2000

  • July 28, 2008 at 12:06 am

    #210586

    Hi,

    Are there any issues migrating a sql server database to 2005. I was thinking that I could backup the current databases on 2000 and restore on 2005. Will this work? Are there any issues I may come across that anyone can foresee?

    thanks

  • July 28, 2008 at 1:42 am

    #848977

    bodhilove (7/28/2008)

    Hi,

    Are there any issues migrating a sql server database to 2005. I was thinking that I could backup the current databases on 2000 and restore on 2005. Will this work? Are there any issues I may come across that anyone can foresee?

    thanks

    First, run the Upgrade advisor (this comes with SQL Server 2005). This may find some issues. When you restore the database, make sure you migrate the relevant users/jobs/etc.

    There are many articles that describe what needs extra attention, e.g. http://qa.sqlservercentral.com/articles/Administration/installingandupgradingtosqlserver2005/1943/

    Also, when you restore the database, it will be restored as a 2000 database, i.e. the compatibility mode for the database will be set to 80. (you will need to change this to access all the 2005 features).

    Regards,

    Andras

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

  • July 29, 2008 at 10:30 pm

    #850250

    THANKS Andras,

    If I do this (change the compatibility mode) will it effect my SQL2005 box?

    For example can I apply updates and service packs without any issues?

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

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