O'Reilly logo

Programming Microsoft® SQL Server® 2012 by Leonard Lobel and Andrew Brust

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required