--- Fabrizio Mazzoni <[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]> 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 > [EMAIL PROTECTED] > > ---------------------------(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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org