This topic provides answers to frequently asked questions about schema migration and revision.

Problem description

When data is migrated from a source database to a destination PolarDB O Edition database, an error message for schema revision appears. The message indicates that the annotation at the beginning of the MCSS TABLE T_CUST_BUSINESS field is missing and every field must be prefixed with an annotation.

Cause
The metadata is case-sensitive. The columns that correspond to the metadata cannot be found in the destination database.
Solution
  1. Log on to the PolarDB console.
  2. In the top navigation bar, select the region where the destination PolarDB O Edition cluster resides.
  3. In the left-side navigation pane, click Clusters.
  4. On the Clusters page, find the PolarDB O Edition cluster that you want to manage and click the Cluster ID.
  5. In the left-side navigation pane, click Parameters.
  6. Find the polar_comp_redwood_raw_names parameter and set the value to off.

Problem description

When the schema is migrated, the message "schema "dbms_aq"does not exist" appears.

Cause
The account of the destination database does not have sufficient permissions.
Solution
Use a superuser account of the destination database to create another migration project.