> -----Original Message-----
> From: Cedar Cox [mailto:cedarc@visionforisrael.com]
> Sent: 23 January 2001 09:43
> To: Dave Page
> Cc: 'Nicholas Chan'; Postgresql Interfaces
> Subject: RE: [INTERFACES] Re: extremely newbie questions
>
>
>
> On Mon, 22 Jan 2001, Dave Page wrote:
> >
> > I believe there was once some Access code that did it
> (though I don't know
> > where it is). I doubt that it migrated tables, indexes,
> data as well as
> > primary and foreign keys as the upcoming pgAdmin will! The
> current version
> > does tables indexes and data BTW.
>
> Is this it? www.cynergi.net/prod/exportsql/
> At the time I looked at it only mSQL v1, mSQL v2 or MySQL was
> supported
> but there is someone that added PG support. I ended up just
> hacking up
> some quick and not _so_ dirty code to get my data into PG.
> It lets the
> ODBC driver do the work. I've attached it for your amusement.
No it wasn't - I forget who wrote it but I recall that he/she did used to
contribute to this list occasionally.
Nice code BTW. It's easy to forget the joys of being able to SELECT INTO
across databases! You should see the current code in the pgAdmin Migration
Wizard - it's somewhat more complex to say the least!