Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Location
    Pittsburgh PA
    Posts
    2

    Unanswered: MySQL connection to Oracle

    We're looking at a product that uses MYSQL to monitor our network systems (our current product uses SQL Server). Each month, information for an executive report, is combined from several different sources (SQL Server, DB2 and Oracle) into one Oracle database which is then queried by our reporting system. We use DTS to push data from SQL Server and all of our DB2 data is brought over via Data Mirror. I was wondering what would be the best (and cheapest) method to get data from MySQL into Oracle. This would need to be automated. I was thinking a shell script that dumps the data out of MySQL and then uses SQL*Loader to get the data into Oracle.

  2. #2
    Join Date
    Oct 2002
    Location
    greenwich.ct.us
    Posts
    279
    There is an option to mysqldump that allows you to dump the data out in "Oracle" format (which basically means the syntax of the DDL will be correct for Oracle). mysqldump --help for options.

    Otherwise, get to know Perl.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •