Re: Convert Filemaker Pro db to Postgresql db

On Fri, 6 Apr 2001, Scott Gritton wrote:

> I've been reading through the lists but have not been able to find any
> information about how to take a Filemaker Pro database and convert it into a
> Postgresql database.
> Does anyone have any information on how to do this type of conversion?
> Thanks!

(My suggestions are a bit speculative. I gave it a day to see if any real
FM users would respond; since none have, I hope this is better than
nothing... :-) )

It's been ~4 years since my fingers touched FileMaker Pro (I understand
it's much nicer now...).

Can FM generate DDL ('create table foo...') statements? If so, you can
dump your data that way.

In FM, can you access ODBC-linked tables? If so, you can copy the data
that way.

Or, do you have any scripting ability? You could write a
Perl/Python/PHP/P-whatever script to connect to FM and connect to PG. PG
has database connectors for all of these languages.

If you're stuck, perhaps it would help non-FM-users on the list for you to
give us a sense of what you can do w/your FM data.

HTH,
--
Joel Burton <jburton(at)scw(dot)org>
Director of Information Systems, Support Center of Washington