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

  1. Host your FileMaker file on FileMaker Server.
  2. Set up a MySQL database with the same tables and fields as your FileMaker file.
  3. 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.
  4. 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

  1. Enter your migration settings and connection info into the form below.
  2. Click the Migrate Data button.
  3. Wait.

What to expect

  1. MigrateFM will send an email message to you with a link to the progess log.
  2. MigrateFM will check the connection information.
  3. 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.
  4. 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.
  5. 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?
Do you want us to actually migrate the records from FileMaker to MySQL?
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?
Enter the layout prefix you used for the FileMaker layouts (e.g. MIGRATE_)
We'll need send you a couple messages while processing the data.
Tables are processed in alphabetical order. Enter a table name to skip tables lower in the alpha order.
Tables are processed in alphabetical order. Enter a table name to skip tables higher in the alpha order.
FileMaker Server Connection Info
The internet address of your FileMaker Server (e.g. http://fms.example.com/)
The name of the FileMaker file you want to pull records from (e.g. BusinessDB.fp7)
The user must have the fmphp extended priviledge enabled for MigrateFM to work.
We totally store your username and password to hack your database later. Kidding!
MySQL Server Connection Info
The address of your MySQL server (e.g. mysql.example.com:3306)
The name of the MySQL database you want to write records to
The user must have be allowed to connect remotely for MigrateFM to work.