O'Reilly logo

Programming Microsoft® SQL Server™ 2008 by Leonard Lobel, Andrew Brust, and Stephen Forte

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

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

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