Micah G

This is very true and we're looking into that. This however is problematic. While ODBC is a conduit for talking to Filemaker, and implements a similar interface, each program has it's own ODBC driver which facilitates communication. The problem with ODBC is that each DB engine implements it differently, so every vendor needs to supply a driver. Filemaker supplies an ODBC driver for Windows and OS X, but there is not one for Linux. If you have implemented this on Linux and know how to do it without the driver, I would very much like to know. Thanks, Micah

As the original post states, we have FM9 Server Advanced. I know what comes on the CD. I'm wondering if anyone knows of a third party that supplies a driver for Linux.

ODBC is a way of connecting to a database not running on your system. I want to connect to FM on Mac OS X Tiger from my Linux webserver.

Repointing table relationships is fine. I'm more worried about scripts and layouts than resetting the relationships. Can we rename an existing table and replace it with a MySQL view of the same name, reset the relationships and have everything work like before?

Does anyone know of one that exists?

Due to the whole system being tied into the structure of an unwieldy non-normalized table, I felt it would be easier to migrate the FM system piece by piece while allowing non-FM development to continue with a fully normalized data structure. I wanted to present a MySQL view of the de-normalized data so the FM system would function as before.

I was wondering if it is possible to migrate a table from FM9 to MySQL with minimal effort in FM. This table has over 300 fields and a lot of relationships. The purpose of this is to normalize the data in the table without rewriting the whole FM app. Can I create a view in MySQL that matches the order and names of the fields in FM and replace the FM table with a MySQL View? What steps are needed to make this work in FM?