Replacing FileMaker with Free Software?

jhealy1024 asks: "I'm looking for a way to replace our FileMaker DB solution with an open-source RDBMS. Problem is, FileMaker's GUI and report design tools are pretty darn good, and I can't find a suitable replacement. Anybody out there have a solution that doesn't require me to take a year off to hand-code a replacement solution?" "I'm the netadmin for a small private school. Since we're Mac-based, we've grown up storing all our data in FileMaker, including student information, grades, class assignments, gifts, inventory tracking, and just about anything else you can think of.

FileMaker is coming out with version 7, which is going to require us to tear all our databases to pieces and build them up again from scratch. While the new FileMaker is an improvement, it's still a toy as far as "real" databases go. (The latest update just introduced relational tables, for example). Also, data lock-in is becoming a problem; I'd like to have access to all our data from non-FileMaker interfaces (to populate our LDAP directory, for example). While we can work an export from FileMaker, it would be much better if the data were available in an open, standard database instead.

I figure, so long as we're rebuilding everything from scratch for version 7, why not use a "real" RDBMS (no flames about which, please). Problem is, FileMaker does two things very well:

1. Rapid development of front-end data entry screens (using a GUI for layout)
2. Ability to create printable layouts for reporting (mail merges, report cards, etc)

I can program data entry screens myself if I had to (either on the web or on the clients directly), but the printable layouts would kill me. Does anybody know of any package that will allow me to replicate FileMaker's easy interface for use with a RDBMS package such as PostgreSQL or MySQL?

Thus far, the only solution I've found is to use some kind of SQL access plug-in for FileMaker. This way, I get to keep the FileMaker interface but ditch its lousy relational model. Unfortunately, I'd still have to pay for FileMaker, and the SQL plug-in requires tons of extra coding to pass the data from FileMaker to SQL and back again.

I know other people have had to move from small, proprietary systems (FileMaker, Access, etc) before; what have you done to keep the simple user interface alive?"

Comments

hard work, me boy!

[east coast]

Anybody out there have a solution that doesn't require me to take a year off to hand-code a replacement solution

You know, if you work twice as hard it will only take you 6 months to create your own homegrown solution.

Reporting from MySQL

[Anonymous Coward]

I am migrating some applications that I have created in Filemaker to MySQL/PHP, because of the increased flexibility. Reporting has been a problem, but DataVision (datavision.sourceforge.net) is an excellent and easy to use tool. Runs in java, (1.4) so it works everywhere except MacOS 9. For that platform, I use an early version of Elixir Reports (www.elixirtech.com) Elixir Reports is not free and buggy, but usable.

Re:Filemaker Pro Migration software

[captnitro]

There is in fact no tool available for Media Access Controllers.

There is also no Microsoft Access available for the Macintosh platform. :)

Re:Filemaker Pro Migration software

[Whalou]

If they say "labtob", they probably just have a cold.

Re:QUIT RECOMMENDING MYSQL!

[capt.mellow]

Holy cow, thanks, I'm going to warn Yahoo that they've been using a toy all these years!