Re: pgMigrate

> -----Original Message-----
> From: Brett Maton [mailto:matonb(at)hotmail(dot)com]
> Sent: 14 January 2002 13:47
> To: dpage(at)vale-housing(dot)co(dot)uk
> Cc: pgadmin-support(at)postgresql(dot)org
> Subject: RE: [pgadmin-hackers] pgMigrate
>
>
> Hi Dave,
>
> Your absolutly right that the syntax is likely to be
> incompatible, but you
> can get the select statement from the DB some how, I down
> loaded ADO Query
> Tool from this guys site todo on the fly SQL with the Access
> DB and it
> manages to get the SQL statements from views....
>

I tried ADO Query - could be quite useful, though it only found the first
column in PostgreSQL views (that may be the ODBC driver though).
Unfortunately the source code on the site is for an old version which
doesn't have this functionality so I can't see how that app is doing it.
I've tried playing the ADOX which is what pgMigration uses, and that refuses
to give the information required with Access, SQL Server or ODBC OLE DB
providers :-(

Anyway, let me know if you come across anything...

Regards, Dave