Home Dashboard Directory Help
Search

Port SQL Compact to Windows RT by Patrick Barranis


Status: 

Resolved
 as Won't Fix Help for as Won't Fix


17
0
Sign in
to vote
Type: Suggestion
ID: 776328
Opened: 1/11/2013 4:51:08 AM
Access Restriction: Public
1
Workaround(s)
view

Description

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.
Details
Sign in to post a comment.
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
Hi,    
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

Sign in to post a workaround.
Posted by ErikEJ on 5/23/2014 at 6:54 AM
brokered winrt components may be able to help you