SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 07:16 AM
| ||||
| ||||
 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?      |
|
02-28-2008, 07:16 AM
| |||
| |||
| Re: how can i migrate data from oracle to mysql? "news.yaako.com" <mpdizxn@126.com> wrote in message news:dq70e0$96v$1@news.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? http://dev.mysql.com/doc/migration-t.../en/index.html I have not used it myself, but from the documentation 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. |
|
02-28-2008, 07:16 AM
| ||||
| ||||
| Re: how can i migrate data from oracle to mysql? Bill Karwin wrote >I have not used it myself, but from the documentation 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, www.mysql.com Are you MySQL certified? www.mysql.com/certification |
Linear Mode
