Re: Conversion to postgresql

Top Page
Attachments:
Message as email
+ (text/plain)
Delete this message
Reply to this message
Author: Emmanuel Gravel
Date:  
To: PLUG list
Subject: Re: Conversion to postgresql
On Sat, 2004-05-22 at 09:19, Craig White wrote:
> 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).


Actually, as long as you're running on Windows, it's pgAdmin II (not
III) that has had a migrator plugin from MS Access to PG. I've used it a
few times already, does relatively nicely, except for a few data types
(can't remember though, do a few tests first).


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