SQL Server: Find out edition specific features that are enabled in current database – sys.dm_db_persisted_sku_features

Hi Friends,

There is a way how you can find out any edition specific features that you are using in your current database. These edition-specific features may not be supported in all editions of SQL Server. Run the following DMV (simple 😉

select * from sys.dm_db_persisted_sku_features

The above code returns of feaure_name and feature_id. Feature_name is the external name of the feature that is enabled in the current database but might not supported on all the editions of SQL Server. This feature, therefore, must be removed before the database can be migrated to all available editions of SQL Server.

In case you are not using any of those edition-specific feature, no rows are returned.

Well, possible values of the feature_name could be Compression, Partitioning, TransparentDataEncryption, ChangeCapture. ALso note that you require VIEW DATABASE STATE permission on the database to run the above DMV.