User Tools

Site Tools



This shows you the differences between two versions of the page.

Link to this comparison view

fm2sql [2006/08/30 10:33] (current)
Line 1: Line 1:
 +=== Converting a Filemaker database into a SQL table ===
 +The easiest way to convert a Filemaker database is using the fm2sql-tool (you can download it [[http://​​itgroup/​toolserver/​fm2sql|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**
 +  - 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...''​).\\ {{unclassified:​fm.jpg}}
 +  - Be sure that the database allows multiple users (''​File -> Sharing... ->''​ select ''​multiuser''​).
 +  - Start fm2sql by doubleclicking on it. If this doesn'​t work open the file with the ''​Jar Launcher''​.\\ {{unclassified:​fm2sqlcommentary.jpg}}
 +  - As source database choose ''​localhost:​yourportnumber''​. For example ''<​nowiki>​jdbc:​fmpro:​http://​localhost:​8050</​nowiki>''​.
 +  - 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.
 +  - As destination database enter the address of the database where the new SQL table shall be located. For example ''<​nowiki>​jdbc:​fmpro:​http://​xserve02/​echo</​nowiki>''​.
 +  - 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).
 +  - You should now see something like that:\\ {{unclassified:​fm2sqlselect.jpg}}
 +  - 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.
fm2sql.txt · Last modified: 2006/08/30 10:33 (external edit)