Sync Framework a substitute for networked clients? RRS feed

  • Question

  • I have a somewhat unusual question I would love to get some opinions on but some background first.

    I work for a medical device company and our typical environment consists of one or more instruments connected to a PC in a network (all local). There may be more than one PC with or without its own set on instruments connected to it. One of the PCs acts as a server and hosts SQL Server. We typically use a TCP/IP interface and transmit binary records suited to our needs.  Communications, validation, additional processing, UI updates, re-transmittal, etc. essentially happen "real time".

    We are currently undergoing an architecture re-engineering project and it has been suggested that instead of continuing the use of a TCP/IP interface that we instead distribute databases and synchronize them using Microsoft's Sync Framework. I don't know enough about the Sync Framework and am a long time TCP/IP guy so I have certain biases about it.

    Anyone ever tried doing such a thing?


    Wednesday, September 21, 2011 2:18 PM

All replies

  • i suggest you go thru the tutorials/walkthroughs to find out yourself if it fits your requirements.

    Sync Fx simply grabs incremental updates from one replica and applies it on another target replica.

    But if you needed to do some processing/transformation on the data before applying it on the target, you might want to evaluate if the hooks provided by the framework is enough for you to intercept the changes and manipulate them.

    Sync Framework also does not fire a sync, you have to explicitly invoke the sync process.

    you can find the tutorials in the documentation that comes with the framework or here: http://msdn.microsoft.com/en-us/library/bb902853(SQL.110).aspx

    Thursday, September 22, 2011 1:48 AM