MigrateFM
MigrateFM moves data from FileMaker to MySQL
If you need to move data from FileMaker to MySQL, you might want to read this.
Before you begin
Host your FileMaker file on FileMaker Server.
Set up a MySQL database with the same tables and fields as your FileMaker file.
Create a layout in FileMaker for each table. Name each layout something like MIGRATE_Person, where Person is the table name and MIGRATE_ is a unique prefix chosen by you. For best results, make sure that the migrate layout names are unique.
Make sure that each layout has all the fields that you want to migrate for the given table. Do not include any fields from related tables or portals.
Let 'er rip
Enter your migration settings and connection info into the form below.
Click the Migrate Data button.
Wait.
What to expect
MigrateFM will send an email message to you with a link to the progess log.
MigrateFM will check the connection information.
If you indicated that you want to run error checking, MigrateFM will make sure that the FileMaker layouts and fields match up with the tables and columns in MySQL.
If you indicated that you want to migrate the records, MigrateFM will loop through the FileMaker layouts and create corresponding records in MySQL.
NOTE: Any pre-existing records in MySQL are deleted in this process.
MigrateFM will send an email message to you to let you know that the process is finished.
Migration Settings
Do you want us to make sure that the fields on the FileMaker layouts match the fields in the MySQL tables?
Yes
No, I'm sure everything is perfect
Do you want us to actually migrate the records from FileMaker to MySQL?
Yes
No, this is just a dry run
Migrating records from FileMaker will begin by DELETING ALL RECORDS from your MySQL database! Make a backup of your MySQL data if you are the least bit concerned by this.
If we get an error inserting records into MySQL, do you want us to stop the process or continue?
Stop
Continue
Layout Prefix
Enter the layout prefix you used for the FileMaker layouts (e.g. MIGRATE_)
Email Address
We'll need send you a couple messages while processing the data.
Start Table (optional)
Tables are processed in alphabetical order. Enter a table name to skip tables lower in the alpha order.
Stop Table (optional)
Tables are processed in alphabetical order. Enter a table name to skip tables higher in the alpha order.
FileMaker Server Connection Info
FileMaker Host
The internet address of your FileMaker Server (e.g. http://fms.example.com/)
FileMaker File
The name of the FileMaker file you want to pull records from (e.g. BusinessDB.fp7)
FileMaker Username
The user must have the fmphp extended priviledge enabled for MigrateFM to work.
FileMaker Password
We totally store your username and password to hack your database later. Kidding!
MySQL Server Connection Info
MySQL Host
The address of your MySQL server (e.g. mysql.example.com:3306)
MySQL Database
The name of the MySQL database you want to write records to
MySQL Username
The user must have be allowed to connect remotely for MigrateFM to work.
MySQL Password