First time here? Check out the FAQ!
x

Best way to load dump in Postgres.

0 votes
asked by about Bullzip MS Access to PostgreSQL
edited by

I am using Bullzip to covert Microsoft Access to Postgres 9.4. I used create dump file method which created a .sql file. It only took couple of minutes to create sql file about 35MB.

I am running the script from pgadmin -> pgscript and it is not completing in 30 minutes.

Do you have any recommendation in loading the data? If psql / or loading direct would be faster?

1 Answer

0 votes
answered by (309k points)

There is no advanced process or some kind, since the application's interface is pretty straightforward.

For a simple way to pass the database to PostgreSQL, you will need the ODBC driver. There is a page on the developer's website where this process is explained. I recommend you access the following URL to learn how to properly add the database to PostgreSQL.

Tutorial page: http://www.bullzip.com/products/a2p/info.php

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register
...