O'Reilly logo

Microsoft SQL Azure: Enterprise Application Development by Jayaram Krishnaswamy

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

Synchronizing SQL Azure data with SQL Server Compact

There are many problems encountered by both users and enterprises when users try to connect to the corporate database remotely. These are usually due to network problems, data access speeds, single point of failure like server going down, and scalability (many users trying to connect). Occasionally Connected Application (OCA) overcomes these by providing not all but just the needed data that is cached on a local, small footprint database that can be synchronized with the corporate database when conditions are favorable. A prime candidate for this kind of application is Microsoft SQL Server Compact edition (SQLCE). It is an embedded database that allows integration of desktop and mobile applications. ...

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