Migrate MS Access to PostgreSQL [closed]

Question

Closed. This question needs to be more focused. It is not currently accepting answers.

Want to improve this question? Guide the asker to update the question so it focuses on a single, specific problem. Narrowing the question will help others answer the question concisely. You may edit the question if you feel you can improve it yourself. If edited, the question will be reviewed and might be reopened.

Closed 6 years ago.

Improve this question

I'm getting data as an Access file.

My application uses PostgreSQL/Java. I'd like to convert the Access database to PostgreSQL. can any one help me to code this

thanks Nguyen...i have done code to connect ms access and postgres(two seperate connection).i dont know how to continue...how to get the table structure... — ess
– ess, Commented Dec 26, 2013 at 6:37
Can you create an ODBC DSN which points to your PostGreSQL db, and then use DoCmd.TransferDatabase from an Access session? — HansUp
– HansUp, Commented Dec 26, 2013 at 16:15
@HansUp can u explain DoCmd.TransferDatabase it is VB is nt it.... i dont know VB — ess
– ess, Commented Dec 27, 2013 at 4:49

James King · Accepted Answer · 2013-12-26 06:55:32Z

0

I doubt there is any simple automatic method. You will have to create ddl statements to make the tables in postgresql (not sure if you can export ddl from access), export the data from access to a csv, and then use postgresql copy from command to populate the tables.

Or you could consider trying this tool:

http://docman.sourceforge.net/home_html/projects/sql/exportSQL3.txt

but it looks like a dev version, it may not be mature.

edited Dec 26, 2013 at 6:55

answered Dec 26, 2013 at 6:45

James King

6,3954 gold badges27 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

James King Over a year ago

I thought you just needed to do a one time conversion. You need to write a java program that will convert MS Access databases to postgresql databases? This sounds like a very big project. I think you need to show us what you've coded so far.

ess Over a year ago

.i have done code to connect ms access and postgres(two seperate connection).i dont know how to continue...how to get the table structure.

James King Over a year ago

Neither do I, unfortunately. If this were Oracle you could pull it out of the metadata. I think you need someone who knows access better than I do.

Collectives™ on Stack Overflow

Migrate MS Access to PostgreSQL [closed]

1 Answer 1

3 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Linked

Related