On Thu, 2004-05-20 at 16:23, Trent Shipley wrote:
> On Thursday 2004-05-20 15:34, Craig White wrote:
> > Have data in Filemaker Pro - want to move it to postgresql
> >
> > Filemaker can export to tab delimited, csv, dbf
>
> Short version:
>
> See the pg COPY command.
----
well, it's better than nothing. I was hoping for a little more magic ;-)
----
>
> > apparently there was a utility called dbf2pg but all links to that are
> > dead
> >
> > There is a commercial product called 'Filemaker Migrator' - commercial
> > ($100) not too much money to buy but destroys open source initiative.
>
> ( @#$% dogmatic freeware fundamentalists.)
----
I am rapidly losing my pragmatism ;-)
----
> (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
----
>
> 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öaut;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
(text/plain)