Upgrade MSDE to SQL 2005 Standard

  • Pretty self-explanatory, I guess!

    I want to take 5 DB's on one server (all in different instances of MSDB) and upgrade them to SQL 2005 Standard. I've found some documents on upgrade each instance to 2005 Express, is there any difference doing it to Standard?

    How do I merge all of the different DB's into the single SQL 2005 instance?

    Thanks everyone!

  • Set up the server, back up the databases from each of the MSDE servers/instances, restore them in the 2005 server. Test that they work. It really should be that simple.

    Are you planning on leaving them in 2000 mode (compatibility 80), or moving them to 2005 (compatibility 90)?

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • I'm going to change them to compatability mode 90.

    Restoring them from a .bak/.bkf file from MSDE to SQL 2005 will work? I....wasn't aware of that!

  • Microsoft recommends a few steps when upgrading from 2000 to 2005 for any database. The upgrade wizard should tell you what you need to change. Make sure to run that on all the databases before you move them.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • Hi all,

    I have been given the task of upgrading a bunch of MSDE databases to 2005 standard edition.

    The install will be used to manage MS ISA Server logs.

    There is an MSDE named instance on this box but it doesn't look like there is a default one.

    - has anyone done this before? (MSDE - 2005)

    - is it even necessary? (can you not jsut install 2005 and restore the MSDE DB's to 2005)

    thanks in addv.

    Carlton..

  • Carlton Leach (9/29/2008)


    restore the MSDE DB's to 2005

    that's exactly what you do

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

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

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