SQL Server: Identifying Edition Specifc features Used in a Database

nelsonaloor, 2013-06-26

I had a situation which forced me to do a feasibility study to move SQL server 2008 enterprise edition environment to standard edition. It is hard to check is there any edition specific features are implemented in any of the databases. It will be more complex process if the environment contain many databases.

There are features like data compression,partitioning,Transparent Data Encryption(TDE) and CDC which are available only on specific edition. The databases, that use these edition specific features can not be moved  to an edition that does not support this feature.

Microsoft has provided a DMV, sys.dm_db_persisted_sku_features to list all the edition specific featured implemented in a database. This can be used as given below:

SELECT * FROM sys.dm_db_persisted_sku_features

For me, it given the below result.










If the query does not return any result , the specific database does not used any edition specific features and can be moved to any edition of SQL server.

If you liked this post, do like my page on FaceBook 

Rate

Share

Share

Rate

Related content

Database Mirroring FAQ: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup?

Question: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? This question was sent to me via email. My reply follows. Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? Databases to be mirrored are currently running on 2005 SQL instances but will be upgraded to 2008 SQL in the near future.

Robert Davis

2009-02-23

1,567 reads

Networking – Part 4

You may want to read Part 1 , Part 2 , and Part 3 before continuing. This time around I’d like to talk about social networking. We’ll start with social networking. Facebook, MySpace, and Twitter are all good examples of using technology to let…

Andy Warren

2009-02-17

1,530 reads

Speaking at Community Events – More Thoughts

Last week I posted Speaking at Community Events – Time to Raise the Bar?, a first cut at talking about to what degree we should require experience for speakers at events like SQLSaturday as well as when it might be appropriate to add additional focus/limitations on the presentations that are accepted. I’ve got a few more thoughts on the topic this week, and I look forward to your comments.

Andy Warren

2009-02-13

360 reads