[FX.php List] A question about synchronization

[Chris Hansen]

Bob,

Could you set up a script that runs periodically (say every half hour)  
and uses the import script step (pointing at a PHP page that serves as  
an XML data source)?  Would you even need to use the VPN for that?  I  
know that sometimes outgoing traffic is allowed even when incoming is  
not...  Just a thought.  Personally, I really like import XML as a  
tool.  Best,

--Chris

On Mar 26, 2010, at 5:18 PM, Bob Patin wrote:

> 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
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list