On 7/25/07, Sytze de Boer <[EMAIL PROTECTED]> wrote: > Biggest problem that I see is the synchronizing of this data.
Full, true synchronization is hard. As Brian indicated, if you could record a log of what changes are made and "play them back" at the home office, (the equivalent of log shipping), you can get some of the way there, but that ASSuMEs there are no changes to matching records at the home office. If there's a way that people can "check out" or "reserve" a block of records: clients, orders or whatever and lock them so no changes happen at the home office, that would work. Replication is non-trivial and if they really need full master-master (vice master-slave, which is more of publisher-subscriber) than you'll want to look at commercial products that provide this (MSDE-SQLServer or MySQL or Oracle or...). If the remote access solution would work (perhaps via a web interface to your application?) that can be a winner, too. -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com _______________________________________________ Post Messages to: ProFox@leafe.com 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.