Port SQL Compact to Windows RT - by Patrick Barranis

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 776328 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 1/11/2013 4:51:08 AM
Access Restriction Public


I would like to see some fort of SQL (Express, Compact, etc) ported to support Windows RT.  With Microsoft's push onto ARM, we would like to be able to build leading-edge Line Of Business apps that allow offline data storage and syncing.  Normally we build applications like this with SQL Express or Compact and Merge Replication.


Additional motivation / information:

We have an application we would like to port to Windows RT, but it uses SQL Compact with Replication.  The only thing standing in our way is that SQL Server isn't yet available in any form (Express, Compact, etc) on Windows RT / for ARM.  The code is all written in WPF and .NET, so it would be a trivial port.  And obviously we don't want to switch to a competitor's SQL technology, like SQL Lite (already available on Windows RT), nor rewrite our own replication & sync mechanism.

We're a consulting shop, and in a given year about half of the apps we build require offline storage and sync'ing (so well over half of our entire company's revenue is from solutions built on SQL Merge Replication - either compact or express).  So unfortunately the majority of our business makes it difficult to ever build apps for Windows RT without SQL Compact being ported to ARM.
Sign in to post a comment.
Posted by Anstroy95 on 6/10/2015 at 11:59 AM
Is better for me being new on Databases migrating from SQL CE to SQL Express?
Posted by PBarranis on 2/18/2013 at 12:49 PM
That's fascinating; thank you for the update! However, can SQL Express Local DB be used in Windows 8 apps for Modern UI? Also, is it supported on ARM processors (i.e. Windows RT)? If so, can you please provide a link to that specific information or documentation?

As best as I can tell, it is not supported and therefore not a solution to the user story presented in this issue (though I would be happy to open a new Microsoft Connect issue for it, if need be).
Posted by Microsoft on 2/18/2013 at 11:52 AM
Thank you very much for your feedback on this issue. SQL Server compact edition is in deprecation mode with no new releases planned near future. Last release SQL CE 4.0SP1 (and earlier releases that are still in the support cycle) will continue to be supported through its lifecycle and Microsoft is committed to fix any major, production blocking issues found in these releases. At this point, we don't consider this issue to be in that category and hence we are closing this issue.
On the desktop/laptop deployments, migrating to SQL Server LocalDB/SQL Express is a possible option for many of the current users (http://msdn.microsoft.com/en-us/library/hh510202.aspx)

thanks for your support