If you’ve used Merge Replication to sync SQL Server Compact data on mobile devices with SQL Server in the past and you’re looking for a cross-platform solution to take you into the future, take a look at Zumero.
As many of you know, I spent most of the first decade of the 21st century building massive-scale mobile enterprise solutions for the world’s largest companies. The backbone of many of those architectures was based on the Merge Replication technology built into SQL Server that allowed mobile devices running the embedded SQL Server Compact database to sync data and take it offline for use with mobile apps. This was a great solution that took care of all the bi-directional, mobile-to-server data movement, conflict resolution and filtering without writing any code allowing development teams to focus on their apps. Unfortunately, the journey for this Microsoft technology arrived at the end of the road with SQL Server 2012 and SQL Server Compact 3.5 SP2. It’s no longer supported on the more recent versions of those products.
For those of you who need to keep synchronizing mobile data with SQL Server, the folks over at Zumero have a solution you should investigate. They smartly took a dependency on SQLite as the mobile database since it already runs on iOS, Android and Windows. The Zumero server runs on an Internet Information Server (IIS) to broker communications between devices and your SQL Server database. This architecture should look familiar to those of you who have built mobile Merge Replication infrastructures in the past.
They’ve even gone so far to provide you with a migration document that will help move you from SQL Server Compact and Merge Replication to their Zumero offering. If this solution matches the scenario you’re targeting, I would encourage you to perform your own due diligence and see if Zumero meets your needs.
Sharing my knowledge and helping others never stops, so connect with me on my blog at http://robtiffany.com , follow me on Twitter at https://twitter.com/RobTiffany and on LinkedIn at https://www.linkedin.com/in/robtiffany