DAC Import/Export (BACPAC) with SQL Compact Edition?

Question

I was reviewing this page:

http://social.technet.microsoft.com/wiki/contents/articles/2639.aspx#_FAQ

It lists all of the editions of SQL Server that that DAC Import/Export feature will work with.  Notably absent is SQL Server Compact Edition.

More and more applications these days are being created to support SQL CE 4.0.  Even Entity Framework and NHibernate can target this.

Is there a limitation of the BACPAC feature that it cannot import or export from SQL Compact?  Or is this oversight of the documentation?

 

I realize SQL CE has a limited subset of SQL Server and SQL Azure features - but surely it should be possible to take a BACPAC export of a SQL CE 4.0 database and import it to SQL Azure?

 

Thanks,
Matt

 

Answer 1

Matt,

The lack of CE support is not an oversight or a documentation problem, DAC Framework currently does not support operations against SQL CE.  We are looking at adding support for at least exporting from SQL CE but don't have a timeframe for a preview or release of the feature.  Thanks for the feedback.