Enterprise Data Synchronization with Microsoft SQL Server 2008 and SQL Server Compact 3.5 Mobile Merge Replication

I’m happy to say that my latest book is now available on Amazon.

With the world’s largest organizations rolling out tens of thousands of Windows® phones, laptops, tablets and Netbooks to empower their respective mobile workforces, the ability to create mobile line of business solutions that support large numbers of users is absolutely critical. In my fourth book on mobile infrastructure and development, I show you how to take the SQL Server data you use to run your organization and make it available to all of your mobile employees.

Step-by-step, I’ll walk you through the process of building a secure, performant, n-tier, mobile enterprise application platform architecture designed to scale to thousands of users. You’ll also learn how to create occasionally-connected .NET applications designed to thrive in unreliable wireless conditions.

Enterprise Data Synchronization with Microsoft SQL Server 2008 and SQL Server Compact=

  • Learn how to “Mobilize” your organization by making your enterprise data available to employees carrying Windows® phones, laptops, Netbooks and tablets in the field.
  • Learn how to build an N-Tier Mobile Sync infrastructure that will scale to thousands of users.
  • Learn how to create occasionally-connected .NET applications designed to thrive in unreliable wireless conditions.
  • Learn best practices in security, reliability, performance, load-balancing, reverse proxy and hardware configuration.
  • Learn how to implement this technology in real world scenarios like supply chain management, retail, sales force automation, healthcare and emergency management.

Keep in mind that the knowledge you gain from this book didn’t come from me dreaming this stuff up in an Ivory Tower.  It came from building some of the worlds largest and most complex data synchronization systems for the world’s largest companies.  In addition to the hands-on experience that went into this book, I’d also like to thank some of my colleagues for their invaluable contributions:

  • Liam Cavanagh is a Senior Lead Program Manager for Microsoft’s Sync Framework and Cloud Data Services and he wrote the forward.
  • Catherine Wyatt is the Managing Editor for Hood Canal Press who made the publishing of the book possible.
  • Darren Shaffer is the CEO of Handheld Logic and he wrote the Chapter on building the Mobile Subscriber.
  • Michael Jimenez is a Mobility Architect at Microsoft and he wrote the Appendix that shows you how to create an ISA Server 2006 Reverse Proxy to publish your sync infrastructure to the Internet.

It’s my sincere hope that this book will encourage you to un-tether your workforce from their desktop computers and boost your organization’s agility by pushing out critical business functions to the point of activity where employees are empowered to make timely decisions and perform tasks that best serve the interests of their customers and their company.

This repudiation of the traditional “connected” software application model increases customer satisfaction, boosts worker efficiency, reduces “missed opportunities” and results in cost savings as “un-wired” employees get their jobs done wherever they happen to be.


Sharing my knowledge and helping others never stops, so connect with me on my blog at https://robtiffany.com , follow me on Twitter at https://twitter.com/RobTiffany and on LinkedIn at https://www.linkedin.com/in/robtiffany

Sign Up for my Newsletter and get a FREE Chapter of “Mobile Strategies for Business!”

[mc4wp_form id=”5975″]

Enterprise Data Synchronization with Microsoft SQL Server 2008 and SQL Server Compact 3.5 Mobile Merge Replication
Tagged on:                                                                         

Rob Tiffany

Rob is a writer, teacher, speaker, world traveller and undersea explorer. He's also a thought leader in the areas of enterprise mobility and the Internet of Things.

7 thoughts on “Enterprise Data Synchronization with Microsoft SQL Server 2008 and SQL Server Compact 3.5 Mobile Merge Replication

  • February 4, 2010 at 7:50 am

    Hi Rob,

    I’m a happy owner of your previous data sync book with SQL2005 and CE3.1. I have now bought this newwe version of the book to be in line with SQL2008/CE3.5.

    I was wondering if you would be able to share with me the load testing tool that you use for the scale-out testing of merge replication? I am currently embarking on a project to development a new system using CE3.5 on CF2.0, and as part of this I need to do some POC testing in regards to load/scale on our hardware. The test tool that you use looks absolutely fit for this purpose, and try as much as I can, I can’t find anything as useful in the community.

    Any help you could give me would be appreciated.



  • March 19, 2010 at 8:52 pm

    Great book.

    A thought –
    Server Agent – does fit neatly into the magazine metaphor:
    Associated Press feeding and receiving input from many reporters to refine and track an evolving story – seems to fit nicely.
    Editor acting as clearing house, channels to push details through, protocols for reconciling details – hey .. maybe :-).

    By the way – great authorship.
    Concepts and practical application instead of a world of details,
    gets to thinking – solutions.


  • April 17, 2010 at 8:14 am

    Rob, I have your book and have configured everything perfectly from start to finish… well not perfectly, there is still something wrong. I get a password error everytime I try to initialize the Contoso Mobile Database from the Windows 6.0 Visual Studio emulator. I have more information and screenshots. Could you help me please? Its probably something simple but I’ve been struggling with it for hours. My email is in the required section. I’m sorry to bother you with this, but you are the only person I have to turn to! Thank You.

  • April 17, 2010 at 10:29 am

    I figured I should give you all the info here, to avoid having to email back and forth. Thank you SO MUCH for your time!!!

    My setup is ALL on my laptop, with SQL Server 2008, IIS, SQL CE with Tools installed, Visual Studio 2008, and everything is configured “per the book” with my SQLCE Server Agent diag & stats pages work fine. ContosoBottlingPub is ready and waiting for a subscriber!

    The problem is with the Subscriber. I’m using Visual Studio 2008, I’m running your app (which is a great tool!), it comes up, I configure my Login Credentials using the Generator, and copy the replcred.bin file to all of the directories on my HD under C:\ContosoMobile\.
    NOTE, the app says to copy it to the application folder of the Mobile Device. How do I do that? I’m guessing putting it in the C:\ContosoMobile directory should do the trick? But this could be the problem.

    What happens is, when I launch the ContosoMobile app, I get an error “Could not initialize the Contoso Mobile database, please send the app tracefile to support…”.

    1) When I dig further I’m seeing an ISQLW Error: Incorrect Password. The DB Notes state
    Error: DB_SEC_E_AUTH_FAILED. The specified password does not match the database password.
    Param.3: \Program Files\ContosoMobile\ContosoMobile.sdf

    NOTE, I can’t see the .sdf anywhere on the Device. Is it hidden, or just not getting there?

    2) I also see an output file stating “Error Code 80072EE7, A request to send data to the computer running IIS has failed. For more information, see HRESULT.” (no idea where HRESULT is.)

    3) Am I not putting the replcred.bin file in the right place? I don’t see it on the HH, but it could be a hidden file type.

    4) Where is the tracefile? I see a beautifully written TraceFile.cs, but can’t find a path to where it is being written to.

    Help Pleeease!

    Oh, here is my Config File, “G5HYRK1\G5HYRK12008” being the SQL Server 2008 Instance where the ContosoBottling DB is installed, as well as the Distributor and Publisher.

    Thank you sooo much for any advice!!

  • April 17, 2010 at 10:34 am

    Okay, I’m officially pushing my luck with you guys. BUT… I noticed the XML didn’t copy to the previous Comments, so re-pasting it here (minus the leading
    appSettings key=”AUTO_SYNC_INTERVAL_DAYS” value=”2″/>
    appSettings key=”CONNECTION_CHECK_URL” value=”http://www.microsoft.com”/>
    appSettings key=”REPLICATION_DISTRIBUTOR” value=”G5HYRK1\G5HYRK12008″/>
    appSettings key=”REPLICATION_PUBLICATION” value=”ContosoBottlingPub”/>
    appSettings key=”REPLICATION_PUBLISHER” value=”G5HYRK1\G5HYRK12008″/>
    appSettings key=”REPLICATION_PUBLISHER_DB” value=”ContosoBottling”/>
    appSettings key=”REPLICATION_SUBSCRIBER” value=”Subscriber”/>
    appSettings key=”REPLICATION_URL” value=”http://G5HYRK1/ssce/sqlcesa35.dll”/>

  • April 19, 2010 at 1:07 pm

    Nevermind, I’m sorry about bugging you guys. I finally noticed in your Handset Code Snippet (in the book) that you have hardcoded your password in the app. Then I found it in the code and see it is encrypted. (sorry, I should have known your login data wasn’t a suggestion, it was literal!) So I wrote my own app and although I’m still quite not there yet I’m very close.

    Your book is great, Thanks so much for writing it! I hope to have this hurdle crossed today.

    Best Wishes!!

  • March 24, 2011 at 5:21 am

    It feels good to seek out such an fascinating subject on the web like this data synchronization on these days. I was greatly interested with what you’ve shared and posted with us. Thanks for this anyway.Sales Force Automation


Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.