mac Live connection between two filemaker databases

[Johnny777]

Is it possible to form a live connection between two filemaker databases

We have the following set up:

Firstly all filemaker software is filemaker 9.

A filemaker database on a mac host machine using filemaker server advanced

A local network of clients in the same location

A database sitting on remote windows machine

Is it possible to form a live connection between the database on the mac server and the database on the remote windows so any changes on the client machines in the local network are automatically saved to the database on the remote machine. Please note the database on the windows machine must be open at all times.

 

There is a working ODBC connection between the windows machine and the host server machine, which is tested and working, so no issues with firewalls etc.  

 

We can do sql queries to update the remote machine but is it possible to form a permanent live connection and what would be the steps  to do this

 

I attach a small diagram of the network configuration which hopefully makes it a bit clearer

 

[Wim Decorte]

Yes, but it is not going to be straightforward depending on how resilient it has to be.  Your best bet is to check out SyncDek from worldsync.com.

[David Jondreau]

Why do you want to do this, compared to, say, having the user at the Windows location connect to the Mac machine?