How to migrate the database from Filemaker to Mysql?

mysql database migration filemaker database-migration
med picture med · Aug 14, 2011 · Viewed 14.7k times · Source

I am rebuilding an ERP system based on Symfony1.4 and MySQL 5.1. The challenge is that previous system was built on Filemaker Pro and I have to migrate all previous data to current system. For that, first I need to move all the data to a MySQL DB having the previous schema structure intact and then I can map the data to the current system schema by writing a script as needed.

How should I proceed with that first step? Is there any existing tools or processes to do that?

Any help will be appreciated! Thanks in advance!

Answer

Mikhail Edoshin picture Mikhail Edoshin · Aug 14, 2011

The simplest way is to export data from FileMaker into some common format. To do this you need to open the file in FileMaker and for each table you need go to the layout associated with the table and use the menu to show all records and export.

Make sure to only export data fields (Text, Number, Date, Time, and Timestamp), because it's typical for FileMaker to have lots of calculated fields (Calculation and Summary). (To do this first go to File - Define Database, then to some table, sort files by type, and note the last data field.

This won't export container fields, but most apps don't store such data. It's still possible to export them too but it would require a custom script.

The next option is to use ODBC. It's 'next' because it's less convenient and usually slower.

If you don't have a copy of FileMaker, you can download a 30-day trial from their site; it's fully functional.

Related questions

How can I rename column in laravel using migration?

I have columns as mentioned bellow: public function up() { Schema::create('stnk', function(Blueprint $table) { $table->increments('id'); $table->string('no_reg', 50)->unique(); $table->string('no_bpkb', 50)->unique(); $table->string('nama_pemilik', 100); $…

Read More
Backup MySQL users

How do I backup MySQL users and their privileges? Anything like mysqldump? I am looking for something like: mysqldump -d -u root -p MyTable > Schema.sql

Read More
Mechanisms for tracking DB schema changes

What are the best methods for tracking and/or automating DB schema changes? Our team uses Subversion for version control and we've been able to automate some of our tasks this way (pushing builds up to a staging server, deploying …

Read More