On Sep 28, 2005, at 2:37 PM, Sujay Koduri wrote:
I don't know how far this is going to help you. But this is what we
are
following to migrate from Oracle to MySQL.
If we were migrating, that's probably the strategy that we would
use. But we are not, at least not yet. For now we just want to be
able to join two tables which reside in different databases (Oracle
and MySQL). What I'm hoping is one of the following:
1) I can link an Oracle table into MySQL using ODBC
2) I can link a MySQL table into Oracle using ODBC
I have found docs that hint that (1) is possible, but haven't found
anything that says "Here's how you do it." As for the second option,
I discovered something called "Oracle Heterogeneous Services" which
may be the ticket, but again, I haven't found anything that says
"Here's how you do it."
Personally, I would prefer option (1) over option (2) because that
would then provide a clear path and an incentive for migration to MySQL.
Regards,
- Robert
http://www.cwelug.org/downloads
Help others get OpenSource software. Distribute FLOSS
for Windows, Linux, *BSD, and MacOS X with BitTorrent
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
