检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
Solution If you want to overwrite the data in the existing database, back up the existing data and delete the database with the same name. Alternatively, set Overwrite Data to Yes when creating a backup migration task, and then migrate the data again.
Handling suggestion: Delete the objects with the same names as the source objects and perform the verification again. Parent topic: Database Objects
Handling suggestion: Delete the read replicas from the destination database. After the migration is complete, create read replicas. Parent topic: Destination DB Instance Statuses
If you manually add, modify, or delete a record, the DRS data comparison result will be inconsistent. If you scale up storage of a RDS database, it is an internal operation of RDS and does not affect DRS tasks. Parent topic: Product Consulting
Solution Contact destination database O&M engineers to delete the corresponding table from the destination database. In the task list, locate the target task and click Resume in the Operation column to resume the task.
You can also stop or delete an unused migration task. Parent topic: Destination DB Instance Statuses
Handling suggestion: Delete the foreign key, disable the trigger, or change the value of session_replication_role to replica. Parent topic: Database Parameters
Statement for granting the DML permission on all tables in the schema: GRANT SELECT, UPDATE, INSERT, DELETE, INDEX, ALTER ON ALL TABLES IN SCHEMA <schema> TO <user> Statement for granting the DML permission on a specified table in the schema: GRANT SELECT, UPDATE, INSERT, DELETE,
In this case, you can only delete the backup database and perform full and incremental backup restoration again. SQL Server does not have the last backup file in a strict sense. If you select No by mistake, you can perform an incremental backup (even if no data is changed).
Solution Run the following SQL statement to delete or rename the foreign key constraints with the same name in the destination database: select * from information_schema.REFERENTIAL_CONSTRAINTS where CONSTRAINT_NAME = "foreign_key_name"; In the task list, locate the target task and
When the system variable innodb_force_recovery is set to be greater than 0 in the destination database, the INSERT, UPDATE, and DELETE operations are disabled in the destination database.
Handling suggestions: Delete the destination database views that have the same names as those in the source database. Alternatively, do not migrate the views with the same names. Parent topic: Conflicts
Return to the object selection page, delete the tables where a generated column is a primary key or unique key from the synchronization object, and perform the pre-check again. Parent topic: Database Parameters
Solution Contact the O&M engineers to delete the tables that do not have primary keys from the destination database. In the task list, locate the target task and click Resume in the Operation column to resume the task.
Table 1 Advanced features Feature Description Dynamically adding or deleting subscription objects During data subscription, you add or delete subscription objects as required. Viewing subscription data View the incremental data on the management console.
Resource rightsizing View DRS task monitoring metrics on the Cloud Eye console, restore failed tasks, and delete idle tasks in a timely manner. Purchase a task with the small specifications for workloads requiring low performance stability to reduce costs.
Handling suggestion: Do not synchronize indexes or delete some indexes so that the number of indexes in a single table in the source database does not exceed 64.
after the migration) Reference statements: GRANT CONNECT ON DATABASE database_name TO ptd; GRANT USAGE ON SCHEMA schema_name TO ptd; GRANT SELECT ON TABLE table_name TO ptd; GRANT SELECT ON SEQUENCE sequence_name TO ptd; GRANT SELECT ON pg_catalog.pg_authid TO ptd; GRANT UPDATE, DELETE
Attempting to delete, rename, or change the passwords or permissions for these accounts will cause task errors.
DRS converts the update operation to delete and insert operations by default. During the insert operation, the log does not contain data of other columns. As a result, an error is reported. Solution Change the supplemental log level of the source database to ALL.
