Before data migration, Data Transmission Service (DTS) checks whether a database with the same name as the source database exists in the target database system. If no such a database exists in the target instance, DTS creates a database. If the automatic creation fails, the precheck fails.
In the following cases, DTS cannot automatically create a database in the target instance and the precheck fails.
The name or character set of the source database do not comply with rules in the target RDS instance.
- The name of the source database contains special characters other than underscores (_) and hyphens (-).
- The character set of the source database is not UTF-8, GBK, Latin1, or UTF-8 (MB4).
- Create a database in the target RDS instance that complies with the naming convention
and character set rules. For more information, see Create a database for an RDS for MySQL instance.
Note When you create the database, you must grant permissions to the target database account that is used by the data migration task.
- Log on to the DTS console.
- In the left-side navigation pane, click Data Migration.
- Find the data migration task and click Edit Task.
- Click Set Whitelist and Next in the lower-right corner of the page.
- Configure the name of the target database by using the object name mapping feature. For more information about how to use this feature, see Object name mapping.
- Click Precheck.
The permissions granted to the target database account are insufficient
- Grant read and write permissions to the target database account. For more information about how to change permissions, see Modify the permissions of a standard account for an ApsaraDB RDS for MySQL instance
- Perform another precheck