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?
A
Answer by
Alex Urbach
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.
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?
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