Smart client & merge replication

• stvhull

  Hall of Fame

  Points: 3710

  More actions

  February 6, 2008 at 9:31 am

  #181645

  Good Day

  We are considering using Smart Client & Merge Replication (between SS2K5 Standard server & Express clients, via HTTPS), to build an application that allows for disconnected processing. I've read enough articles that certainly make it seem feasible to do, but what I can't seem to find is any real life experiences, to find out what limitations / thresholds / issues / surprises people have encountered, before we start down this path. Other than being selective and limiting how much data you subject to merging, I haven't found much else. Anyone with advice or pointers regarding this topic?

  Thanks

• dbaker-620086

  SSCrazy

  Points: 2336

  More actions

  February 8, 2008 at 7:21 am

  #776415

  using Merge Replication implies possibility of conflicts and need for resolution strategy

  - this has been largely roll-your-own in SQL200x [e.g. with RMO] if basic offering no good

  MS is putting lotsa dev effort in SQL2008 to catch-up with other mobile players [e.g. Sybase]

  suggest you follow these URLs on Sync Services, and play with the CTP's

  http://blogs.msdn.com/synchronizer/archive/2007/12/13/what-s-new-in-sync-services-for-ado-ne-2-0.aspx

  http://blogs.msdn.com/synchronizer/