SQL 2008 R2 Enterprise to SQL 2019 STANDARD - is this possible?

  • Can I migrate databases running on SQL 2008 R2 Enterprise to SQL 2019 STANDARD edition.  The databases are NOT using any Enterprise features.

  • Yes very possible as long as you have verified no Enterprise features are actually in use.

    But that being said some enterprise features became available in standard edition from 2016SP1.

    The only thing I would say is to test, test, test the living daylights out of everything.

    If your planning in changing the compatibility level above 120 you’ll run into the new cardinality estimator and you may or may not notice performance issues you will need to work through.

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

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