Hi Joel,
I'm not a FM user so I actually don't know about its capabilities.
I've been given the assignment to convert our FM bug database over to
Postgresql and was hoping that there was a tool out 'there' that could
accomplish this without me having to spend a lot of time on the process of
conversion.
I'm just starting to script with Python and will be looking into how I might
be able to do the conversion that way if I can't find any easier way.
Thanks for your reply!
Scott
-----Original Message-----
From: Joel Burton [mailto:jburton@scw.org]
Sent: Saturday, April 07, 2001 11:42 AM
To: Scott Gritton
Cc: 'pgsql-general@postgresql.org'
Subject: 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@scw.org>
Director of Information Systems, Support Center of Washington