On Fri, 2004-05-21 at 07:36, Derek Neighbors wrote:
> 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.
----
Hmmm - I already downloaded and set up the Linux version and didn't see
anything like that. Perhaps I should install a copy on my Windows
machine to see if there is a connector for odbc data sources to pull
them through (I like your forklift term). As for access...my Windows
machine is MS Office free and I think I want to keep it that way
(loosely translated - not much enthusiasm for pirated copy or
purchasing).
----
> 
> 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*.
> 
----
Yeah and I'm thinking that since I am charging my customer for my time -
my pragmatism has to diminish as his costs escalate so the $100
commercial product is looking pretty good at the moment.
----
> 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.  :)
----
You are a fountain of knowledge and an awesome resource. Thanks

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