On 5/7/12 2:39 PM, MB Software Solutions, LLC wrote: > Good points, but begs the question: is this a 1-way synch or 2-way? In > other words, are changes on the laptop only going to the server, or is > it possible for server changes to be newer than the laptop and thus you > go that direction (from server to laptop db)? If you have the date/time > stamping like Stephen said, it helps make this possible.
I have five things to offer as requirements for true 2-way synchronization between any number of clients: 1) all timestamps stored in UTC (duh). 2) all clients sync with ntp server regularly to avoid time drift 3) UUID primary keys generated on the client side 4) transaction log kept on server and on client for use in the 2-way sync 5) syncing a client to a server should block other clients from syncing at the same time Paul _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
