Post reply

Testing an upgrade from SQL 2016 to SQL 2017 Standard

  • April 2, 2019 at 12:13 pm

    #2501548

    Is using the developer versions of SQL server a good way to test an upgrade from SQL server 2016 standard to SQL Server 2017 standard? I have used the migration adviser to find possible issues and would like to test the upgrade now.

    Thanks,

    Dan

  • April 2, 2019 at 2:10 pm

    #2512608

    Developer edition is a full version of SQL Server so it would be equivalent to Enterprise edition in live. You will need to be aware of this whilst testing as there will be some features available in Developer that won't be available in Standard.

    Thanks

  • April 2, 2019 at 2:18 pm

    #2513701

    I understand the differences. I just want to be able to see if anything breaks when I do the upgrade. I have always done fresh install and restored the backups, so this is a new one for me.

    Thanks for the reply.

  • April 2, 2019 at 2:23 pm

    #2514310

    I would always do a fresh install and then restore the databases. If you do an in place upgrade there is always the chance that something could go wrong during the upgrade and you won't be able to recover.

    Thanks

  • April 3, 2019 at 4:29 am

    This was removed by the editor as SPAM

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

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