By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,933 Members | 1,686 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,933 IT Pros & Developers. It's quick & easy.

Migrating Access to Postgres

P: n/a
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 ma*******@postgresql.org

Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
On Wed, Oct 01, 2003 at 09:23:44AM -0600, Bernardo Robelo 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.


Have a look at http://gborg.postgresql.org/project/...rojdisplay.php

Cheers,

Patrick

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 12 '05 #2

P: n/a
On Wednesday 01 October 2003 16:23, Bernardo Robelo 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.


pgadmin (v3) is a useful tool:
http://www.pgadmin.org/pgadmin3/index.php

There is some advice here:
http://techdocs.postgresql.org

You might find the odbc driver useful:
http://gborg.postgresql.org/project/...rojdisplay.php

I prefer to use the ODBC driver to link to tables in PG and gradually migrate
that way. A lot of people say pgadmin is great for migrating, though I've not
used it for that.

--
Richard Huxton
Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 12 '05 #3

P: n/a
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 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" <br*****@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 ma*******@postgresql.org


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 12 '05 #4

P: n/a

--- Fabrizio Mazzoni <ve*******@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" <br*****@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

ma*******@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

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.