I have 2 Webservers running IIS

I have 2 FileMaker Server Advanced

I want the ability to have high availability where if one server completely dies, the other one takes over. My big concern now is on the database replication. I want to have identical and always up to date by the minutes database on both FileMaker Server.

Apparently there is no replication process per se with filemaker and after having spoken to tech support, they suggested that I create a script to commit a record on every Insert / or UPDATE to both databases. How do I go about doing that exactly? He said to link the script to every table. I am new to FileMaker. If there's a better way to perform database replication/synchronizations, I be happy to hear it. If someone can steer me in the directions of the right script commands to use and how to apply the script to start? This script would need to be able to be web-compatible. Thanks in advanced everyone.

http://www.syncdek.com/

I found that too through my googling research. Though the problem with that solution is the cost of it. $1k/license for each server. It's going to cost altogether $2,500+.

My temporary solution was for any INSERT or UPDATE of any records, it would have to be done via my own web form and using ODBC, i can create connections to 2 db. All editing of records would have to be done via my web forms/php scripts but doing this would create a tremendous amount of maintainence and development work

Edited July 16, 200619 yr by Guest

I know it is quite an old post, but I would like to help anyone who stumbles upon this entry in the future. The beta of my synchronisation solution which does not need a FileMaker Server (to save hosting and license cost for your customers) was just released: FileMaker data replication (synchonisation) tool (runs on all FileMaker products) http://www.filemaker-sync.com