Re: Migrating Access to Postgres

--- Fabrizio Mazzoni <veramente(at)libero(dot)it> wrote:
> Hello .. i did the migration and my advice is that
> you forget about the automatic translation tools...

I have used the "migration wizard" that comes as a
plugin for PgAdminII, and was very happy with the
result. Yes, you can do everything by hand, but why?

>
> I took the access database and recreated all af the
> tables and relationships between them manually in
> postgres. I also added all 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 text file) 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 export the 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 in the
> 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(at)agssa(dot)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(at)postgresql(dot)org
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 7: don't forget to increase your free space map
settings

__________________________________
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com