A client has outgrown their Access database, and now I need to convert it to PostgreSQL. I don't have a lot of Access experience, so at first blush it seems like the best solution is to just export the data using text files or something.
Does anyone have any good suggestions for an easy way to get the DDL and data out of Access and into something real?
You should be able to write something that can see them both with ODBC or something, but failing that you could dump it to a text file or use a commercial tool.
This is an old script that I has not been updated in a while, but I used for a similar purpose: http://code.activestate.com/recipes/52267/
Another commercial option: http://www.datanamic.com/dbzipper/index.html
Take a look at the tool from http://dbconvert.com/convert-access-to-postgresql-pro.php?DB=1