Re: Access-postgreSQL migration (extra invalid foreign key added)

> -----Original Message-----
> From: Reshat Sabiq [mailto:sabiq@purdue.edu]
> Sent: 23 December 2002 02:58
> To: Dave Page; pgadmin-support@postgresql.org
> Subject: RE: [pgadmin-support] Access-postgreSQL migration
> (extra invalid foreign key added)
>
>
>
>
> -----Original Message-----
> From: Dave Page [mailto:dpage@vale-housing.co.uk]
> Sent: Sunday, December 22, 2002 2:31 PM
> To: Reshat Sabiq; pgadmin-support@postgresql.org
> Subject: RE: [pgadmin-support] Access-postgreSQL migration
> (extra invalid foreign key added)
>
>
> -------
> It's certainly possible. The Migration Wizard is a bit hit
> 'n' miss to be honest as I wrote it without ever migrating a
> database except for the odd test using Northwind/Biblio.
>
> Is it possible to get a schema only copy of your mdb file to
> look at please?
> -------
> Sure. How should I get that schema? I have the postgreSQL
> statements in pgAdmin, but I don't know how to obtain the
> same from Access.

Sorry, I don't know about Access. The statements from pgAdmin are of
little use though as I want to see what it should have generated, not
what it did.


> ---------
> We do sort of assume there are no \n's or \r's in your object names...
> ---------
> That is correct; I do not have new lines in object names. In
> fact, I shouldn't have any in that database. But I was
> thinking it might be there behind the scenes. But it is
> strange that only 1 out of 10 foreign keys get the invalid
> duplicate statement.
>
> P.S. Thanks for the great tool. Things like that can get done
> with time.

You're welcome.

Regards, Dave.