Thread: convert MSAccess to PostgreSQL 7.3.2

Dear Sir/Madam,
I am trying to export my MSAccess database to PostgreSQL (Linux platform)
I tried to install Migration Wizard for pgAdminII but it does not appear 
in the "Plugin" menue although
I have installed following
MDAC 2.8
Jet 4.0 SP8
and registered pgMigration.dll
Is there Migration Wizard plugin for pgAdminIII? Is there other 
possibility to convert MSAccess to Postgresql 7.3.2 ?
Thank you very much,
Oleg

> -----Original Message-----
> From: Oleg [mailto:evdakov@iwk.uka.de]
> Sent: 26 November 2003 12:55
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] convert MSAccess to PostgreSQL 7.3.2
>
> Dear Sir/Madam,
> I am trying to export my MSAccess database to PostgreSQL
> (Linux platform) I tried to install Migration Wizard for
> pgAdminII but it does not appear in the "Plugin" menue
> although I have installed following MDAC 2.8 Jet 4.0 SP8 and
> registered pgMigration.dll Is there Migration Wizard plugin
> for pgAdminIII? Is there other possibility to convert
> MSAccess to Postgresql 7.3.2 ?

Hi Oleg,

Unfortunately there is no migration wizard in pga3. My only suggestion
is to re-register the dll for pga2 - in the 3 or so years it's been out
noone has ever reported this problem so I can only assume it didn't
register correctly the first time round. You might also try a manual
registration from the Tools  -> Options dialogue.

Alternatively, I believe there are some papers on database migration on
http://techdocs.postgresql.org.

Regards, Dave.