Replication: FileMaker to SQL Server

[amberdextrous]

Hello all,

My company uses MS SQL Server 2005 and FileMaker Pro 6. I'm developing an application that needs to access FileMaker data, but it needs to get it from a SQL Server table. So, I need to be able to automatically replicate the data from a table in FileMaker to a matching table in SQL Server. Is there a way to do this? The 2 tables need to be kept in sync, so I can't just set up an export to run every night. I know there's a replication feature in SQL Server, but I'm not sure if I can use that feature with a FileMaker database.

Any help would be appreciated! I've been looking on the web but haven't found much helpful information.

 

[amberdextrous]

Correction: FileMaker Pro 6 is what the client machines use. FileMaker Server 5.5 is where all the data is stored.

 

[philhege]

The scenario you describe would require that Filemaker be a publisher in the replication schema. I don't believe this is possible without a third party solution.

Phil H.
Some Bank
-----------
Time's fun when you're having flies.

 

[amberdextrous]

Found out we have FMConnector, and we can use that along with FileMaker's web companion to replicate data to SQL Server. Not sure about the inner workings, but it does work.