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