|Oracle Migration Workbench Frequently Asked Questions (FAQ)
Release 9.2.0 for Microsoft Windows 98/2000 and Microsoft Windows NT
Part Number A97247-01
This chapter contains frequently asked questions about using the Oracle Migration Workbench to migrate from a MySQL Server 3.22 or 3.23 database to an Oracle Server. It contains the following sections:
This section contains a MySQL data migration question.
No. Performance tests have not been carried out on the Migration Workbench data migration process. However, it is known that the setup affects performance. For example, if the Oracle Server and MySQL are not located on the same server, you must take the network bandwidth into account. Presently, data migration involves reading the data from the source MySQL database through a JDBC bridge and writing the data to the Oracle database through JDBC. It is a straightforward data pump. However, the Migration Workbench takes advantage of array inserts and `commit points' to improve performance. You can use the
mysqldump scripts in conjunction with SQL*Loader to provide offline data loading for non-binary data.
This section contains a MySQL error message question.
You may receive this error message during Step 1: Source Database Details of the Capture Wizard. To resolve this error message, verify the following conditions:
rootuser exists and has sufficient privileges on the MySQL server.
rootuser is correct.
rootuser must be exactly eight characters to allow a connection through a third party product using JDBC or ODBC drivers. This is true even if a password that is not eight characters long allows you to connect through MySQL client programs.