Checking Whether the Names of the Source and Destination Databases Are the Same

Whether the names of the source and destination databases are the same

Check whether the names of the source and destination databases are the same.

Failure cause: This item cannot be checked because the source database fails to be connected.

Handling suggestion: Check whether the source database is connected.

Failure cause: This item cannot be checked because the destination database fails to be connected.

Handling suggestion: Check whether the destination database is connected.

Failure cause: Insufficient user permissions

Handling suggestion: Check whether the database user permissions meet the migration requirements.

Failure cause: During an incremental migration, the source and destination databases cannot have the same names.

Handling suggestion: Determine whether to retain these databases in the destination RDS DB instance or specify another destination RDS DB instance.

Failure cause: An internal error occurs.

Handling suggestion: Contact Huawei technical support.

Whether the names of the source and destination databases are the same

Check whether the source and destination databases have the same names to prevent existing databases from being overwritten. If the source and destination databases have the same name, the migration cannot be performed.

Failure cause: Source database names are the same except for letter cases.

Handling suggestion: Change table names or do not migrate the tables with the same names.

Failure cause: Source database names are the same except for letter cases.

Handling suggestion: Select only one database among the databases whose names are the same except for letter cases.

Failure cause: The source and destination databases cannot have the same names.

Handling suggestion: Determine whether to retain these databases in the destination RDS DB instance or specify another destination RDS DB instance.

Whether the names of the source and destination databases are the same

The mapping names of the tables to be synchronized in the source databases are the same as the names of the destination database tables.

Failure cause: The names of the tables to be synchronized are already mapped to the destination database.

Handling suggestion: Select other tables to migrate or change the mapping names of the tables to be synchronized.

Whether the names of the source and destination databases are the same

The migration fails when the names of the source and destination databases are different.

Failure cause: The source and destination databases must have the same names, except that the destination database must use only lowercase letters.

Handling suggestion: Create a database with name in lowercase letters in the destination database.

Failure cause: The names of the objects to be migrated are the same except for letter cases.

Handling suggestion: Select only one database among the databases whose names are the same except for letter cases.

Failure cause: The names of the tables to be migrated are the same except for letter cases.

Handling suggestion: Change table names or do not migrate the tables with the same names.

Failure cause: The names of the tables to be migrated are the same as those in the destination database and use only lowercase letters.

Handling suggestion: Change table names or do not migrate the tables with the same names.

Whether the names of the source and destination databases are the same

The migration fails when the names of the source and destination databases are different.

Failure cause: Some tables cannot be migrated because tables with the same names already exist in the destination database.

Handling suggestion: Select the tables that do not contain same table names or rename these tables. Command example: alter table old_name rename to new_name

Failure cause: Some databases or users cannot be migrated because the destination databases do not have the databases or users with the same name.

Handling suggestion: Create these databases or users before the migration, or do not migrate these databases or users.

Whether the names of the source and destination databases are the same

Check whether the source and destination databases have the same names to prevent existing databases from being overwritten. If the source and destination databases have the same name, the migration cannot be performed.

Failure cause: The destination database names cannot be the same.

Handling suggestion: Change the destination database names to prevent the database from being overwritten.

Whether the names of the source and destination databases are the same

Check whether the source and destination databases have the same names to prevent existing databases from being overwritten. If the source and destination databases have the same name, the migration cannot be performed.

Failure cause: The destination database names cannot be the same.

Handling suggestion: Change the destination database names to prevent the database from being overwritten.

Whether the names of the source and destination databases are the same

Before synchronization from DDM to Oracle, databases or users with the same names must be created in the destination database.

Failure cause: Some databases cannot be synchronized because the databases with the same names do not exist in the destination databases.

Handling suggestion: Create these database or users in the destination databases or do not migrate these databases.