Re: Oracle to MySQL migration from windows 2003 to linux
Posted by: Michael G. Zinner
Date: June 24, 2005 11:18AM

First, you have to attach the Oracle JDBC driver to the tool. After you have selected Oracle as the Source Database System, click the button to locate the driver on your harddisk. A typical path for the driver is C:\Program Files\Oracle\ora92\jdbc\lib\ojdbc14.jar

Then, on the pages where you specify the source and target database connections you have to enter the correct host.

So, on the Source Database screen you set localhost as Hostname and on the Target Database you set the IP address of the Linux machine MySQL is running on.

Typical source connection settings for Oracle look like this:

Database System: Oracle Database Server
Driver: Oracle Thin JDBC Driver using SID
SID: Oracle9
Hostname: localhost
Port: 1521
Username: system
Password: ****

Typical target connection settings look like that:

Database System: MySQL Server
Driver: MySQL JDBC Driver 3.1
Hostname: 192.168.1.100
Port: 3306
Username: root
Password: ****

You can get more information from the documentation. Choose Help > Help in the main menu.

Mike

Michael Zinner, Team Lead, Developer Tools
MySQL AB, www.mysql.com

Are you MySQL certified? www.mysql.com/certification

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.