Re: Migrating Access to Postgres

--- Fabrizio Mazzoni <veramente@libero.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@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
> 
> ---------------------------(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