Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have a SQL Server 2008 database, up on an Enterprise Edition server. I am wondering if I can move it over to a standard enterprise edition server. Is there any way for me to test the database to see if this type of move is possible, before attempting it?

share|improve this question
    
Define "non-enterprise" - Standard Edition? Workgroup? Express? –  Mark Henderson Dec 21 '09 at 21:51
    
Standard edition. –  blueberryfields Dec 22 '09 at 0:05

1 Answer 1

up vote 3 down vote accepted

sys.dm_db_persisted_sku_features

select * from sys.dm_db_persisted_sku_features

This will not include though any application layer reliance on an EE feature, eg. query optimisations leveraging indexed views. But at least you will know whether the database can be attached safely to a SE instance (no compression, no partitioning, no TDE, no change capture).

share|improve this answer
    
That is restricted to SQL Server 2008. What about for 2005? –  blueberryfields Dec 22 '09 at 19:40
    
In 2005 only partitioning would make a database EE only and you can easily scan for partitoned tables in sys.partitions. See sqlskills.com/BLOGS/PAUL/post/… –  Remus Rusanu Dec 22 '09 at 19:57

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.