Status on SQL migration steps

Discussion in 'Update Services' started by Bobbie Harder \(MSFT\), Jul 29, 2005.

  1. Hi All-
    Wanted to give you status on where we are in testing and documenting the
    best steps for migrating/upgrading to full SQL Server from WMSDE/MSDE for
    these 3 cases:
    1. WMSDE/MSDE and SQL on the same computer
    2. WSUS and WMSDE/MSDE migrating to WSUS and SQL on a destination computer
    (NOTE: this is not remote SQL).
    3. WSUS and WMSDE/MSDE migrating to WSUS on frontend and SQL on backend
    computer (NOTE: this is remote sql)

    We're validating which combination of methods to best achieve this between
    backup/restore and attach/detach, export/import. We're all over it and
    should have the steps documented and out to you all next week. Sorry for the
    delay but want to make sure we nail the best yet easiest process.
    Bobbie Harder
    Program Manager, WSUS

    This posting is provided "As Is" with no warranties, and confers no rights.
    Use of included script samples are subject to the terms specified at
    Bobbie Harder \(MSFT\), Jul 29, 2005
    1. Advertisements

  2. Great news! Thank you for the update, Bobbie.

    I'll be interested in seeing the final recommendations, as I've been
    thinking about this question the couple of times it's been asked in this
    group -- but, alas, hadn't had any time to do any of my own testing.
    Lawrence Garvin, Jul 29, 2005
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.