[FX.php List] A question about synchronization

[Bob Patin]

OK, so now I've done an end-around in the saga with servers and the VPN. I've got a little database running on server A, and the main database running on server B. Now that the little database is in the LAN with the web server, it works fine (as I expected).

Here's my latest challenge: how to get the records from database A on server A into database B on server B.

I can have a script triggered when someone is in the database--that works fine. However, my wish was to have some sort of synch script run after every transaction. 

Jimmy Jones suggested doing it all in PHP--write to database A, then take the same data and write to database B. The problem though, as you guys know, is that the WPE can only connect to a single database server.

Does anyone have a method for doing something like this? Other than having a script run when someone does something in the database, any other ideas? A server-scheduled script won't do it either, since server A doesn't "know" about server B, even though the 2 databases are tied together with a relationship.

Any ideas would be greatly appreciated.

Thanks,

Bob Patin
Longterm Solutions
bob at longtermsolutions.com
615-333-6858
http://www.longtermsolutions.com
iChat: bobpatin
FileMaker 9 & 10 Certified Developer
Member of FileMaker Business Alliance and FileMaker TechNet
--
Expert FileMaker Consulting 
FileMaker Hosting for all versions of FileMaker
PHP • Full email services • Free DNS hosting • Colocation • Consulting
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.iviking.org/pipermail/fx.php_list/attachments/20100326/61267918/attachment.html