Backup Restore from SQL 2012 Developer edition to Standard Edition

As SQL2012 Developer is also having the same functionality as the Enterprise.

so can i restore the backup from Developer editions to Standards and Standard to Developer editions.

How the Cross editions backup and restore in SQL Server 2012 works.

Many Thanks

Ekbal

August 23rd, 2013 3:07am

Hello Ekbal,

It works as long as you don't use any Enterprise Feature like partitioning, CDC etc. You can query it with

SELECT * 
FROM sys.dm_db_persisted_sku_features

It it don't return a result, you can restore Dev Edition database to a Standard Edition; otherwise the restore will fail.
Free Windows Admin Tool Kit Click here and download it now
August 23rd, 2013 3:14am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics