Marty Metras wrote:
> ...
> I want to make a direct link in the SQL to get
> data directlly from the MySQL database from
> ORACLE.
>
> Kind of like this: Where the 2 tables are one
> different servers.
>
> Select o.partno, m.partnumber
> from oracle.PARTmaster_TABLE o,
> mysql.partmaster_table m
> where o.partno = m.partmeaster;
>
> Is there a was to directly link these to DBs?
>
Not to my knowledge, nor do I know whether this will ever be possible.
However, you might be able to achieve something similar if you
export your Oracle data and import it into MySQL regularly, thus
taking a snapshot you could query against. You could even call
the database/schema in MySQL "oracle" if you are so inclined
thus enabling the SQL that you suggested above.
Further, of course you can combine records programmatically
via things like JDBC or DBI where the application itself manages
connections to multiple databases at once, but then you lose the
nice SQL abstraction you were going for.
I certainly know that such a thing could be possible one day, I am just
not aware of any products that do such a thing, nor do I know whether
we plan on building one ourselves.
Regards,
Josh
Josh Chamas
Director, Professional Services
MySQL Inc., www.mysql.com
Get More with MySQL!
http://www.mysql.com/consulting