Access to PostgreSQL conversion
Jeff Smith
jsmith at alum.mit.edu
Tue Apr 19 04:58:00 EDT 2005
--- David J Berube <djberube at berubeconsulting.com> wrote:
> 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,
I'll look at it, how does it compare to mdbtools
(https://mdbtools.sf.net)? Had you heard of that, looked
at it, etc/
jeff
>
> --
>
> 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
> _______________________________________________
> gnhlug-discuss mailing list
> gnhlug-discuss at mail.gnhlug.org
> http://mail.gnhlug.org/mailman/listinfo/gnhlug-discuss
>
More information about the gnhlug-discuss
mailing list