Updated on 2022-09-21 GMT+08:00

Checking Whether the Source Database Table Name Is Valid

MySQL Migration

Table 1 Checking whether the source database table name is valid

Check Item

Whether the source database table name is valid

Description

If the source database table name contains invalid character, the synchronization task fails.

Failure Cause and Handling Suggestion

Failure cause: The source database table names contain unsupported characters, non-ASCII characters, or the following characters: ></\

Handling suggestion: To solve this problem, perform the following steps:

Click Previous to return to the Select Migration Type page. Select a customized object and do not select the table that contains unsupported characters.

Method 2: Change the table name.

PostgreSQL Migration

Table 2 Checking whether the source database table name is valid

Check Item

Whether the source database table name is valid

Description

The source database table name cannot contain single quotation marks ('), double quotation marks ("), and periods (.). Ensure that the source database table name does not contain invalid characters. Otherwise, the synchronization task fails.

Failure Cause and Handling Suggestion

Failure cause: The source database names contain unsupported characters.

Handling suggestion: Run the following command to change the source database names that contain unsupported characters:

alter table old_name rename to new_name;

Oracle Migration

Table 3 Checking whether the source database table name is valid

Check Item

Whether the source database table name is valid

Description

The source database names cannot contain non-ASCII characters or special characters .><\`|,?'!" If the table name or view name of the source database contains any invalid character, the migration fails.

Failure Cause and Handling Suggestion

Failure cause: The table name or view name of the source database contains unsupported characters.

Handling suggestion:
  • Run the following command to change the table name that contains unsupported characters:
    alter table old_name rename to new_name;
  • Run the following command to change the view name that contains unsupported characters:
    rename old_view_name to new_view_name;