dokuwiki

The easiest way to convert a Filemaker database is using the fm2sql-tool (you can download it here (download the fm.jar file from the download page)).

(Attention: fm2sql does not work with Filemaker Pro 8)

How to convert a filemaker database

1. Open the filemaker database you want to convert. Be sure that the Web Companion (Filemaker Pro → Preferences → Program → Plugins) is activated and keep the TCP/IP-port number in mind (select Web Companien, click on configure…).
   
2. Be sure that the database allows multiple users (File → Sharing… → select multiuser).
3. Start fm2sql by doubleclicking on it. If this doesn't work open the file with the Jar Launcher.
   
4. As source database choose localhost:yourportnumber. For example jdbc:fmpro:http://localhost:8050.
5. Click on the button show Tables below the field source database. If you didn't specified a password for your database, then just click ok when you're asked for a password.
6. As destination database enter the address of the database where the new SQL table shall be located. For example jdbc:fmpro:http://xserve02/echo.
7. Click on the button show Tables below the field destination database. Enter username and password (ask the itgroup or the one who gave you the address of the database if you don't know).
8. You should now see something like that:
   
9. Select the database you want to convert (on the left side) and click Convert Tables (on the right side).

Notice: The name of your filemaker database (the name of the Filemaker file) will be the name of the SQL table. If there is already a table with that name, the table is overwritten by the new table created from your filemaker database. The fields of the SQL table have the same names as the fields of your filemaker database.