This feature is available in SQL Server 2014. i.e., the database has a MEMORY_OPTIMIZED_DATA filegroup. In Memory OLTP: Indicates that the database uses In-Memory OLTP feature. This feature is available in SQL Server 2008/R2 and Higher Versions.

Before restoring the database on to an Enterprise or a Developer Edition one must remove data compression using ALTER TABLE or ALTER INDEX statements and to remove VARDECIMAL storage format one must use SP_TABLEOPTION statement. This feature is available in SQL Server 2012 and higher versions.ĭata Compression: Indicates that at least one table or an Index within the database Data Compression or the VARDECIMAL storage format. Before restoring the database on to an Enterprise or a Developer Edition one must DROP or ALTER the index. This feature is available in SQL Server 2008 and Higher Versions.Ĭolumn Store Index: Indicates that at least one table within the database uses In Memory Optimized Column Store Index. One can remove CDC feature using sys.sp_cdc_disable_db stored procedure. Using sys.dm_db_persisted_sku_features Dynamic Management View (DMV) you can list the following database-changing features as restricted to the SQL Server Enterprise or Developer editions in SQL Server 2008 and higher versions.Ĭhange Data Capture: Indicates that CDC feature is enabled for a Database. Hence it’s better to know which features are supported before one goes ahead and restore the database on new a server.įind SQL Server Enterprise Edition Features in Use? There are some Enterprise Edition only features which are not available on other editions of SQL Server. One of the most common tasks performed by the DBA is to moving user databases across different editions of SQL Server especially during Disaster Recovery Situations.

Sql server enterprise manager