AWS DMS迁移任务不会自动递增源表

0

【以下的问题经过翻译处理】我正在尝试对用AWS DMS 迁移 Amazon RDS MySQL 到 Amazon Aurora MySQL。源表中的数据已经成功复制，我在数据库上执行了一次alter table操作，这会使主键自动递增。然而，每当数据插入到数据库中时，目标都没有被更新。数据复制任务中是否有任何配置允许我执行此操作？还是需要手动完成？

Topics

Migration & Modernization Analytics Database

Tags

AWS Database Migration Service Amazon Aurora

Language

中文 (简体)

EXPERT

rePost Polyglot

asked 9 months ago52 views

1 Answer

Newest
Most votes
Most comments

Are these answers helpful? Upvote the correct answer to help the community benefit from your knowledge.

0

【以下的回答经过翻译处理】不建议使用AWS DMS来迁移schema（使用mysqldump）。这种方法可能会导致问题，例如您正在遇到的问题，其中标记为auto_increment的列未成功迁移。

EXPERT

rePost Polyglot

answered 9 months ago

Relevant content

sagemaker美国人口普查数据在中国宁夏区下载提示拒绝访问
LiuChuang
asked a year ago
S3上无法使用Chunked上传文件｜ Unable to use Chunked to upload files on S3
rePost-User-1798329
asked a year ago
怎样通过CloudFormation来给DocumentDB创建一些表和索引(how to create some table and index in DocumentDB by CloudFormation）
Accepted Answer
Dgk
asked a year ago
Sites on Amplify become very slow recently. Amplify站点最近突然变得很慢。
Zhu
asked a year ago
How do I troubleshoot binary logging errors that I received when using AWS DMS with Aurora MySQL as the source?
AWS OFFICIALUpdated 2 years ago
How do I troubleshoot and resolve high CPU utilization on my Amazon RDS for MySQL or Amazon Aurora MySQL instance?
AWS OFFICIALUpdated 2 years ago
What are the best practices to follow when migrating a source RDS MySQL database to a target RDS MySQL database using AWS DMS?
AWS OFFICIALUpdated 2 years ago
How do I migrate to an Amazon RDS or Amazon Aurora DB instance using AWS DMS?
AWS OFFICIALUpdated 2 years ago
Connect to your Amazon Aurora MySQL DB cluster
EXPERT
Gayathri Krishnamoorthy
published 10 months ago
Migrate from MySQL running on VMware Cloud on AWS to Amazon Aurora using AWS Database Migration Service (DMS)
EXPERT
Koichi Takeda
published 7 months ago