Creating an Occasionally Connected System

At the time of this writing, Data Sync does not support direct synchronization between mobile devices and SQL Server or SQL Azure. Although this functionality may be added to a future version of Data Sync, for now, you simply cannot build synchronization capabilities directly into the phone application using Data Sync. But consider as well that you may not want to expose your SQL Server database via the Internet directly to the mobile application. Adding a SQL Azure database to the design to act as a buffer between mobile clients and the on-premise “back office” database introduces an extra layer of security to the solution. With this architecture, you protect SQL Server behind the corporate firewall and ...

Get Programming Microsoft® SQL Server® 2012 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.