Once you get some "Here's how you do it." about option 1, please post it in the lists also. Because we are also looking to do a similar one, but didn't find out any good info.
sujay -----Original Message----- From: Robert Citek [mailto:[EMAIL PROTECTED] Sent: Thursday, September 29, 2005 1:32 AM To: MySQL Subject: Re: Access, ODBC, Oracle, MySQL 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
