Re: Conversion to postgresql

Craig White said:
>> (Appologies if this is insultingly basic.)
>>
>> I don't have much time on Postgresql. It sounds like you either want
>> a direct, magic connection. It would automigrate the Filemaker
>> schema to pg and then autopopulate the same. Migration complete
>> (good luck) .
>>
>> (You *could* write your own with something like PERL with a pg_dumpall
>> file format as the program's output target. That is more work than
>> my lazy programmer self would want to do, however.)
> ----
> not insultingly basic - but it is of course, something that I would
> prefer not to slug through - especially considering my perl skills are
> /dev/null
> ----

For the record I believe pgAdmin III has a "magic" connection. Especially
if you are on windows. If there is a windows ODBC driver from Filemaker I
think that there is a "wizard" in pgAdmin III that will move data from
Access to postgres (table schema, indexes and data) that I have used more
than once to forklift Access Applications to Postgres. I believe that
access has ability to open and read .dbf files. So if you can get your
Filemaker to spit out to a dbf then get Access to read the DBF then you
can use pgAdmin III to move the data to postgres.

Also, GNU Enterprise has a read only csv driver and possibly a dbf driver
(I can recall for certain). I would not be hard to get our schema tool to
use one of these drivers to basically general gnue-schema xml off your
data. Then our tool will convert to postgres for you. This of course
would require some python programming so the pgAdmin III option is better
if you are looking for pure *magic*.

Hope this helps. I am swamped until soccer season ends otherwise I would
offer to come and meet to show you some options in person. :)

-Derek
>>
>> The next step down would be something like MS SQL Server DTS that
>> provides a slick visual programming language for data migration.
>> (Doesn't exist for pg.)
> ----
> This is actually the sort of thing that this Filemaker Migrator portends
> to be - sort of an odbc redirector - capable of various input output db
> types including dbf/filemaker/mssql/mysql/pgsql/accessdb but of course,
> the most limited is pg.
> ----
>>
>> More realistically you want something like Oracle's SQL*Loader. You
>> would have to re-create the Filemaker schema by hand writing DDL.
>> Then you dump the data from Filemaker table-by-table. Then you load
>> it to the new PG database/schema table-by-table.
>>
>> I had to resort to third party documentation (Geschwinde and
>> Sch&oumlaut;nig 2001) to find that the PG built in for this is the
>> COPY command. It is not nearly as elegant or complete as SQL loader
>> but should work.
>>
>> Note also:
>> http://www.postgresql.org/
>> has a newbie mailing list where this sort of question would no doubt
>> be very welcome.
> ----
> probably so - I wasn't that eager to join another list.
>
> Yes, you were right on the mark - thanks for the insights - I suppose I
> will pony up the $100 but the '@#$% dogmatic freeware fundamentalist' in
> me will feel like I'm cheating.
>
> Craig
>
> ---------------------------------------------------
> PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us
> To subscribe, unsubscribe, or to change you mail settings:
> http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss



---------------------------------------------------
PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us
To subscribe, unsubscribe, or to change you mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss