I have a somewhat unusual question I 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 PC acts as a server and host SQL Server. We typically use a TCP/IP interface and transmit binary records suited to our needs.
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?