Summary
You have many decisions to make when building your occasionally connected system. Choosing between Merge Replication and Sync Services for ADO.NET is only the beginning. Merge Replication is the database administrator’s tool, providing quick setup and configuration with its myriad wizards and dialog boxes but limited choices in terms of platform and topology. Sync Services for ADO.NET is a developer’s dream: total control with a robust object model and lots of interesting possibilities for building occasionally connected client/server or service-based applications.
In this chapter, we explored the development of occasionally connected systems for SQL Server Compact 3.5 using both Merge Replication and Sync Services for ADO.NET coupled with ...
Get Programming Microsoft® SQL Server™ 2008 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.
