Re: Error in Database Migration Wizard with Acc ess DB

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: <keehan_mallon(at)yahoo(dot)com>, <pgadmin-support(at)postgresql(dot)org>
Subject: Re: Error in Database Migration Wizard with Acc ess DB
Date: 2002-04-30 15:43:50
Message-ID: 214E9C0A75426D47A876A2FD8A07426E665C@salem.vale-housing.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

> -----Original Message-----
> From: Keehan Mallon [mailto:keehan_mallon(at)yahoo(dot)com]
> Sent: 30 April 2002 16:31
> To: Dave Page
> Subject: RE: [pgadmin-support] Error in Database Migration
> Wizard with Acc ess DB
>
>
> Dave,
>
> Doesn't look like there are any type maps setup at all. I
> figured that the default values were probably fine, so I
> didn't even look at this.
>
> Anyway, that database itself is rather large (hence the need
> to leave access behind), but I just tried this on another
> (very simple Access
> db) and it fails for the same syntax error.
>
> Can you send me a list of the default type mappings? I will
> set them up by hand if need be for this test.
>

It stores the values under

HKEY_CURRENT_USER\Software\pgAdmin II\Migration Wizard\Type Map

In the registry. Having made suitable backups etc. if you delete the
above key using regedit, then the Wizard should fall back to the default
values next time it is run.

Regards, Dave.

Browse pgadmin-support by date

  From Date Subject
Next Message Karl Swisher 2002-04-30 18:09:36 pgMigration installation error
Previous Message Dave Page 2002-04-30 07:21:36 Re: Error in Database Migration Wizard with Acc