Hello .. i did the migration and my advice is that you forget about the automatic translation tools...
I took the access database and recreated all af the tables and relationships between them manually in postgres. I also
addedall the necessary indexes at design time ..
Basiclly you have to open each table in access in desgn mode and recreate it in postgres (maybe first write it in a
textfile) with sql commands ...eg:
create table foo (a serial primary key, b varchar) ......
After that you have to migrate the queries and recreate them as views in PG...
Then i dumped all the access tables to csv files and reimported them in pg with the copy command. Another solution to
exportthe data from access to PG would be to link all the pg tables in access and execute an insert query from
access....This is a faster solution but sometimes access can run out of memory or you can get differences and errors
inthe datatypes which are very annoying...
I kept access only as a frontend and beleive me this solution gave us a huge boost in production in our company ...
Best Rgeards,
Fabrizio Mazzoni
On Wed, 1 Oct 2003 09:23:44 -0600 (CST)
"Bernardo Robelo" <brobelo@agssa.net> wrote:
> Hi,
> I am interested in migrating Microsoft Access database to Postgres
> database. But I do not have idea of like initiating. Maybe some tool
> exists for this problem.
> Thanks you.
> Bernardo
>
>
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org