Before You Begin
（1） The version of the target self-built MySQL database is 5.1, 5.5, 5.6, 5.7, or 8.0.
（2） MySQL instances are case-insensitive to table names. If a table is created in uppercase, MySQL converts the table name into lowercase before creating the table.
（3） If your self-built Oracle database version is 12c or later, the name of the table to be migrated must contain no more than 30 bytes.
（4） If the source Oracle database contains tables with the same table name but in different case forms, the migrated objects may have the same name and an "Object already exists" message may be displayed during structural migration. If this occurs, use the object rename function to rename the object with the same name when configuring the migration object.
Permission Requirements of Target Server
Migration Mode | Required Permissions |
Full | CREATE, SELECT, ALTER, INSERT, REFERENCES, INDEX, TRIGGER, CREATE VIEW, DROP, CREATE ROUTINE, EXECUTE |
Incremental | SELECT, INSERT, DELETE |
Auditing Repair | SELECT, INSERT, DELETE |
Configuration on Target Server
Data source type: Set this parameter to MySQL. The source database can be migrated to the MySQL databases within the version range.
Server IP: Specifies the IP address of the target database.
Port number: Specifies the port of the target database.
User name: Specifies a user name used to connect to the target database.
Password: Specifies the password of the user used to connect to the target database.
Database: Specifies the name of the database used by the target server to receive data from the source server.