enterprise to standard

Question

Experts, please guide what all parameters to check for restoring a database from enterprise to standard edition so that it is compatible

Answer 1

Hi Vishu-2318,
Thanks for your reply.

will features like ChangeCapture, Partitioning etc give errors while migrating to SQL 2019 standard edition.

SQL Server standard 2019 supports Change Data Capture and Table and index partitioning. SQL Server from 2016 with Service Pack 1 and higher supports CDC and partitioning in the Standard edition.
It is feasible to restore the SQL Server 2008 enterprise database with partitioning and CDC features to SQL Server standard 2019.

Please refer to Editions and supported features of SQL Server 2019 which might help.
Best Regards,
Amelia

Answer 2

If you have access to SQL Server Enterprise and that database, then you can check if Enterprise features are used with

SELECT * FROM sys.dm_db_persisted_sku_features

If you have only the database backup, then you can not check it; restore the database and see if you get an error regarding Enterprise features

See
https://dotnetstories.wordpress.com/2012/06/20/restoring-a-database-from-sql-server-enterprise-edition-to-any-other-edition-of-sql-server/

Answer 3

Hi Vishu-2318,

I think you will need to restore the database to another enterprise or developer edition SQL Server, and use sys.dm_db_persisted_sku_features to list edition-specific feature. Then you need to remove the edition-specific features, take a backup and restore it on the SQL Server standard edition.
In addition, please refer to this article which might help.

Best Regards,
Amelia

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 4

reference to these feature :

https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-db-persisted-sku-features-transact-sql?view=sql-server-ver15&WT.mc_id=Portal-Microsoft_Azure_Support

if the database is in backward compatibility of 100(SQL 2008) on a SQL 2019 enterprise instance , will features like ChangeCapture, Partitioning etc give errors while migrating to SQL 2019 standard ediiton