Re: Conversion from MS Access to Postgresql

G'day.

Having just done it, I can confirm that converting an Access database
to PostgreSQL is very easy.

All I did was as follows:

1. create an empty Postgresql database,
2. cretae an ODBC DSN on the Access machine pointing at the empty
database,
3, fire up Access and Save/As/Export all tables to the ODBC target.

Job done:-))

In fact, I had to do some massage to the results as the export process
does not create indexes nor sequences and I decidesd to change some of
the generated data types.

This was also easy using the pgdump utility to dump the data and the
definition for editing.

Be aware that any column names that include upper case letters in
Access will keep their capitalisation and require quotes in Postgresql.

HTH,
Stephen.
"G.L.Lim" <limgl@grouplinks.com>  wrote:
> Hi,
>
> I am curently using MS Access and would like to convert my existing Access
> database to Postgresql database (maybe into Postgresql dump file first if
> neccessary). Is there any utility or program that can do that? Please
> advise.
>
> Thank you.
>
> Regards,
> Geok Leng




========================================================================
Stephen Davies Consulting                      scldad@sdc.com.au
Adelaide, South Australia.                       Voice: 08-8177 1595
Computing & Network solutions.               Fax: 08-8177 0133