List:General Discussion« Previous MessageNext Message »
From:Sujay Koduri Date:September 28 2005 7:37pm
Subject:RE: Access, ODBC, Oracle, MySQL
View as plain text  
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.

Have a flag keeporacle as long as you want oracle to be in place. 

Open connection to mysql
If (keeporacle)
{
    open connection to oracle also.
}

         if (keepOracle) 
         {
            found = look in Mysql db
            if (not found)
            {
              look in oracle db //Anyway this architecture must be in place
for you.
              insert in MySQL db 
            }
         }
         else
           look in mysql and serve back, if it exists.

Close connection to mysql
If (keeporacle)
{
   close connection to oracle.
}

And once you feel confident that all the data is moved from oracle to MySQL,
take oracle out.

sujay

-----Original Message-----
From: Robert Citek [mailto:rwcitek@stripped] 
Sent: Thursday, September 29, 2005 12:58 AM
To: MySQL
Subject: Access, ODBC, Oracle, MySQL


Is there a way to query data where one table is in an Oracle database and
another is in a MySQL database?

We have two projects.  One project is entirely in Oracle 9i on an MS Windows
2000 server and the other is in MySQL 4.1 on Linux.  It isn't worth our time
at this point to migrate entirely to one or the other.  So I was wondering
if there is a way to query data from two tables, where one table was in one
database and the other table in another?

Currently, I have hacked together a perl script which does what I need.  But
this is not a long-term solution.  So we are looking for other strategies.
One strategy would be to be to use ODBC drivers  
and MS Access to link the two tables within an MS Access database.   
Another strategy would be to link the Oracle tables into MySQL, but I don't
know if that can be done.  Any other strategies?  Pointers to documents or
search terms gladly accepted as my current searches returned a lot of hits
but nothing useful, unless I missed it.

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/mysql?unsub=1
Thread
Access, ODBC, Oracle, MySQLRobert Citek28 Sep
RE: Access, ODBC, Oracle, MySQLSujay Koduri28 Sep
  • Re: Access, ODBC, Oracle, MySQLRobert Citek28 Sep
    • Re: Access, ODBC, Oracle, MySQLSGreen28 Sep
      • Re: Access, ODBC, Oracle, MySQLRobert Citek29 Sep
RE: Access, ODBC, Oracle, MySQLSujay Koduri28 Sep
  • Re: Access, ODBC, Oracle, MySQLRobert Citek28 Sep
RE: Access, ODBC, Oracle, MySQLMikhail Berman28 Sep