Table of contents
- What is EMS Data Pump for PostgreSQL utility?
- What do I need to start working with EMS Data Pump for PostgreSQL?
- I‘ve downloaded a trial version of EMS Data Pump for PostgreSQL, but not all records of the tables are converted. What’s the reason for this?
- I’m trying to import data from MS Access. When I open up a table it shows indices(0), constraints(0) and I cannot select them. How can I fix this?
- I'm testing Data Pump utility to convert an MS Access 2000 database to PostgreSQL but it raises an error of access violation in module msjet40.dll.
Q:
What is EMS Data Pump for PostgreSQL utility?
A:
EMS Data Pump for PostgreSQL is a powerful utility for converting databases and importing table data from an ADO-compatible source (e.g. MS Access or any other database with ADO support) to PostgreSQL databases. Easy-to-use wizard application allows you to build the ADO connection string, select tables, fields and indices for converting, view and edit SQL script for generating target PostgreSQL database and select tables for import. Data conversion becomes as easy as possible with EMS Data Pump for PostgreSQL!
Q:
What do I need to start working with EMS Data Pump for PostgreSQL?
A:
First of all you must have an opportunity to connect to some local or remote PostgreSQL server. Besides you need your computer to satisfy the system requirements of EMS Data Pump for PostgreSQL.
Q:
I‘ve downloaded a trial version of EMS Data Pump for PostgreSQL, but not all records of the tables are converted. What’s the reason for this?
A:
This is a limitation of the trial version which converts only 10% of all records. With a registered version all the records are processed.
Q:
I’m trying to import data from MS Access. When I open up a table it shows indices(0), constraints(0) and I cannot select them. How can I fix this?
A:
The solution to this problem is to use the Microsoft Jet OLE DB Provider for establishing connection to your Access database.
Q:
I'm testing Data Pump utility to convert an MS Access 2000 database to PostgreSQL but it raises an error of access violation in module msjet40.dll.
A:
Try to reinstall the Microsoft Data Access Components (MDAC) 2.8. You can download it from the following page: http://www.microsoft.com/downloads/search.aspx?display