Migrating Filemaker Pro 7 to MySQL?

[wicky]

Hi

I'm looking for a good tool to migrate Filemaker Pro 7 DB's to MySQL... preferably free or as cheap as possible (ie. not several hundred dollars).
=)

I had a look on VersionTracker and came up with "FmPro Migrator", sounds good but was a bit put off my the 1 star reviews.

Has anybody used FmPro Migrator with success? Or, has anybody got a better suggestion?

Ta

[macworks]

I haven't heard of anything automatic. I don't know what your level of experience with MySQL is, but you could simply export your FMP records to a text files with tab-delimited fields. Then use a regular expression find and replace to create insert commands for each record. Then simply pipe the file in to MySQL to populate the MySQL tables. It's a little work, but you'll be much better off knowing how to do this.

I use BBEdit for all of my programming and I'm very happy with it's powerful REGEX find and replace features.

[wicky]

Well, here's the thing.

I have a non-technical client who has a reasonable understanding (& experience) of Filemaker Pro, who wishes to update their own records on a regular-ish basis. They have heard of migrating DB's, and like (love) the concept... more than an HTML interface & definitely more than a text editor.

Given that we are at the pitch stage of the project, telling him it's a non-starter is a luxury that I really don't have.

So, what I'm looking for is the best semi-automatic solution. Any ideas, much appreciated.

Thanks for the feedback BTW.

[mdnky]

http://www.macupdate.com/info.php/id/10736

http://dev.mysql.com/tech-resources/...itepaper01.htm (White-paper from MySQL Developer Resources)

http://www.fmpromigrator.com/

[wicky]

Originally Posted by mdnky

http://www.macupdate.com/info.php/id/10736

Thanks for the links MDNKY. The one quoted above looked pretty useful.... until I tried the download!

[mdnky]

Oops...dragged it from a set of bookmarks. Guess I'll have to remove that one.