Professional Web Applications Themes

how can i migrate data from oracle to mysql? - MySQL

there are two computers.one is installed redhat linux9 and oracle9i,the other is installed fedora4 and mysql5.the two computers' OS are text mode(without x window). in this situation,Show can i migrate data from oracle to mysql?...

  1. #1

    Default how can i migrate data from oracle to mysql?

    there are two computers.one is installed redhat linux9 and oracle9i,the
    other is installed fedora4 and mysql5.the two computers' OS are text
    mode(without x window).
    in this situation,Show can i migrate data from oracle to mysql?


    news.yaako.com Guest

  2. #2

    Default Re: how can i migrate data from oracle to mysql?

    "news.yaako.com" <mpdizxn126.com> wrote in message
    news:dq70e0$96v$1news.yaako.com...
    > there are two computers.one is installed redhat linux9 and oracle9i,the
    > other is installed fedora4 and mysql5.the two computers' OS are text
    > mode(without x window).
    > in this situation,Show can i migrate data from oracle to mysql?
    Have you looked at the MySQL Migration Toolkit?
    [url]http://dev.mysql.com/doc/migration-toolkit/en/index.html[/url]

    I have not used it myself, but from the doentation it appears that you
    could, for example, run this application on a third PC (e.g. Windows or
    Linux with GUI), and connect over the network to both source (Oracle) and
    destination (MySQL) databases on their respective Linux hosts. As long as
    you can reach both databases with a JDBC connection, I think you're okay.

    Regards,
    Bill K.


    Bill Karwin Guest

  3. #3

    Default Re: how can i migrate data from oracle to mysql?

    Bill Karwin wrote
    >I have not used it myself, but from the doentation it appears that you
    >could, for example, run this application on a third PC
    MySQL Migration Toolkit is the right choice for this task. However, keep in
    mind that running the Migration Toolkit on a third PC will move all the
    data twice: once from the source machine to the machine with the MT and
    then again from there to the target machine. Hence if there is a lot of
    data I strongly recommend to start MT on the target machine.

    This works however only if that machine is a Windows box, because currently
    MT is only available for Windows. We are working on the Linux and MacOS
    port already, but this will still take a while until it is ready.

    Mike
    --
    Mike Lischke, Software Engineer GUI
    MySQL AB, [url]www.mysql.com[/url]

    Are you MySQL certified? [url]www.mysql.com/certification[/url]
    Mike Lischke Guest

Similar Threads

  1. Replies: 0
    Last Post: June 1st, 03:15 AM
  2. Trying to BIND data from Oracle
    By slider6 in forum Coldfusion Flash Integration
    Replies: 1
    Last Post: May 25th, 01:17 PM
  3. Oracle Data Access Performance on MX7
    By EricCF in forum Coldfusion Database Access
    Replies: 0
    Last Post: February 27th, 04:38 PM
  4. Flash and Oracle data base
    By Mrinal Banerjee in forum Macromedia Flash Data Integration
    Replies: 2
    Last Post: July 20th, 09:23 AM
  5. migrate from MySQL -> DB2
    By Andreas Korthaus in forum IBM DB2
    Replies: 6
    Last Post: August 25th, 06:57 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139