A move with a view

With new features, there are new things to consider when you’re moving from SQL Server Edition to SQL Server Edition. For instance, certain database operations (such as Transparent Data Encryption)  make changes to the file layouts that make it – interesting – to move to another.

Happily, there’s a view you can access to see the features that have been implemented on a database that might create issues in moving the database. It’s called sys.dm_db_persisted_sku_features, and you can read more about it here:  http://msdn.microsoft.com/en-us/library/cc280724.aspx

Skip to main content