Re: Linking Oracle tables to MySQL

[Marty Metras]

Josh,

Here is kind of what I am doing now.
From the Oracle/UNIX server side I execute a script using ssh to on the MySQL/linux server to create a text file uising filtered data and only 90 days old. THis is about 4000 record now. The text files is FTPed back to the Oracle server and loaded into a temp table. At this point the data from the MySQL database can be linked to the Oracle data to update 50 records or so.
The whole process as it stands is take only 2-3 minutes.

While typing this I had another thought.
When I execute the script I could be passing a list of SalesOrderNo to the MySQL server and load them into a temp table and use them for a filter to get my test data to pass back to Oracle.

The Data on the MySql side is time stamped and there is othe feilds I can use to linit the amount of data I need to send back to Oracle. Right now 90 days is the best I can do.

I was just trying to find a better way to do this.