SQL2017 CTP

  • Does anyone know if I can do an inplace update from SQL2014 to SQL2017 Enterprise?

  • krypto69 - Wednesday, June 21, 2017 6:32 AM

    Does anyone know if I can do an inplace update from SQL2014 to SQL2017 Enterprise?

    Haven't tried it but my question is why would you want to do that?
    😎

  • I would like to see if new version  faster. Look into some of the new features, etc.

    We have a test/dev environment that can be used just for this purpose. So why not?

    But I would like to know if it can do it inplace, if not I will have to schedule and outage or do it off hours. 

    \

  • krypto69 - Wednesday, June 21, 2017 7:05 AM

    I would like to see if new version  faster. Look into some of the new features, etc.

    We have a test/dev environment that can be used just for this purpose. So why not?

    But I would like to know if it can do it inplace, if not I will have to schedule and outage or do it off hours. 

    \

    He he, at least you are not doing this on prod 😛
    It should work but I have not tried it, normally prefer side by side and then detach/attach or restore
    😎

  • SQL Server 2017 is in CTP at the moment, I'm not sure it was be advisable to upgrade your current version to a test product. You would be better setting up the 2017 CTP instance, restoring some of your databases on to it, and then seeing how it handles. If you upgrade your existing Dev/Test environment there's no going back, and you'll have an unsupported test product for a dev environment in a matter of months.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • Thom A - Wednesday, June 21, 2017 7:14 AM

    SQL Server 2017 is in CTP at the moment, I'm not sure it was be advisable to upgrade your current version to a test product. You would be better setting up the 2017 CTP instance, restoring some of your databases on to it, and then seeing how it handles. If you upgrade your existing Dev/Test environment there's no going back, and you'll have an unsupported test product for a dev environment in a matter of months.

    Not just unsupported, but almost certainly timebombed too...

    Thomas Rushton
    blog: https://thelonedba.wordpress.com

  • I'll try it and report back.

    We have very fast SAN snaps to overwrite so not that big a deal to revert.

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

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