Of course it is possible. In fact, it's easy.
Just use JDBC or ODBC or OLEDB or a .NET provider and join to both
database systems.
There is nothing to it.
I can make a join where tables from RMS and DB/2 and Oracle and
PostgreSQL and MySQL are all participating in the SQL statement with
ease.
This technology is 15 years old.
> -----Original Message-----
> From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-
> owner@postgresql.org] On Behalf Of Hrishikesh Deshmukh
> Sent: Thursday, May 26, 2005 2:05 PM
> To: Postgresql-General
> Subject: [GENERAL] Just a crazy idea!
>
> Is it possible to connect a DB in Postgresql to a DB in MySQL!
> I know its a crazy idea!
> H
>
> ---------------------------(end of
broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq