Access to PostgreSQL conversion
David J Berube
djberube at berubeconsulting.com
Mon Apr 18 23:09:01 EDT 2005
Hey all,
While I'm thinking of Access and PostgreSQL, a quick note. I recently
released one of my inhouse Access-to-PostgreSQL conversion tools under
the GPL. Note, however, that Access and PostgreSQL have very different
design methodologies, and a complex database will require reanalysis.
This project will take you much of the way, however, and it includes
source, so it's easy to make incremental modifications to fit your
project.. It can import basic table information and data - it does not,
however, import VIEWs or indices. Both of those should be created by
hand - most complex Access queries will have to be rewritten for
PostgreSQL in any case, since Microsoft-specific functions are not
present in PostgreSQL.
Anyway, here's the URL:
http://sourceforge.net/projects/access2psql/
I've had great success with it so far.
Take it easy,
--
David Berube
Berube Consulting
djberube at berubeconsulting.com
(603)-485-9622
http://www.berubeconsulting.com/
_______________________________________________
gnhlug-announce mailing list
gnhlug-announce at mail.gnhlug.org
http://mail.gnhlug.org/mailman/listinfo/gnhlug-announce
More information about the gnhlug-discuss
mailing list