Use of MySQL migration Toolkit

MySQL migration toolkit is a database migration tool officially provided by MySQL. It can convert any data source to MySQL DATA, or convert Mysql Data to other types of data. Java support required

Supported database migration

• Access-to-MySQL
• DBF-to-MySQL
• Excel-to-MySQL
• MSSQL-to-MySQL
• Mysql-to-access
• Mysql-to-Excel
• Mysql-to-MSSQL
• Mysql-to-Oracle
• Oracle-to-MySQL

Related Links

• Http://www.mysql.com/products/tools/migration-toolkit/ Official Website
• Download http://dev.mysql.com/downloads/migration-toolkit/1.0.html

The following is an example:
MySQL migration toolkit is a MySQL data migration tool (applicable to MySQL or later). It is not complex to use and supports conversion between Oracle, Microsoft SQL Server, Microsoft Access, Sybase, MaxDB and MySQL. The following instances are from Oracle to MySQL.

1. Install jdk1.6

MySQL migration toolkit requires support from jre1.5.0.8 or later.

2. Run MySQL migration Toolkit

Click Start>Program"-" MySQL "-" MySQL migration toolkit "to run MySQL migration toolkit. Click "Next"

3. Select "direct migration" and click "Next"

4. Enter the parameters of the source database you want to convert in "source database ".

"Database System" is the database system type. Select Oracle here.

"Driver" is the driver used;

"Service" is the service name of the source database;

"Hostname" indicates the IP address and port of the source database file;

"Uesrname" is the user name of the source database;

"Password" indicates the user password used by the source database.

When selecting an oracle driver, you may need to load the oracle JDBC Driver (ojdbc14.jar ).

 

 

Other databases may need to manually write JDBC URLs. Write them as needed.

5. Fill in the "target database" with parameters of the converted database type.

The "Database System" database system is a MySQL server;

"Hostname" indicates the Host Name and "Port" indicates the port;

"Username" is the name of the database user;

"Password" indicates the user password used by the database.

 

Here, you need to manually write the jdbc url link: Click the advanced key at the bottom and a box is displayed, prompting you to enter "connection string:" JDBC: mysql: // ip: Port /? User = user & Password = passwd & useserverprep0000ts = false & characterencoding = GBK

 

IP, port, user, and passwd are entered Based on the IP address, database username, and password of the MySQL server.

 

 

6. After the parameters of both databases are filled in, the next step is the server connection.
If "execution completed successfully" is displayed, the server connection is successful, and then click "Next ".

7. Select the database to be migrated
Select the Oracle schema to be migrated.

8. reverse Engineering. If "execution completed successfully" is displayed, the data is successfully converted.
9. object Type Selection
select "objects of Type Oracle table" and "objects of Type Oracle View". To migrate other object types, check the corresponding options.
use "detailed selection" to select objects that do not need to be migrated.
10. object mapping
modify "migration of Type Oracle schema" and "migration of Type Oracle table"
select "generic" for "migration method", and click "set parameter ", select "user defined" and set "charset = GBK, collation = gbk_ci";
11. migration. If "execution completed successfully" is displayed, this step is successful.
12. migrated objects
the problematic ing objects and their creation scripts are listed here, mainly for some views or stored procedures. This tool cannot confirm whether the syntax is correct, another option is to migrate only tables.
13. object creation options
you can choose to create an object directly on MySQL or save it as a script. Create an object using scripts.
If the saving script is in "create script file for create statements", enter the location and name of the exported file. The database table structure is generated here.
14. if "execution completed successfully" is displayed in creating objects, the object is created successfully.
15. "No creation problem found" is displayed in creation results, indicating that there is no problem above
16. select the actual data transmission mode
to transmit data online. When the source and target databases and migration tools are not on the same machine, a large amount of data traffic will be generated on the network, note.
17. The last step is data transmission. After data transmission, a summary is generated to check whether the migration process is correct.

Article Source: feino net (www.firnow.com): http://dev.firnow.com/course/7_databases/mysql/Mysqljs/20100713/434231.html