migrate database schema and data from RDS Mysql 5.7 to Mysql 8.0

Hi,

Thank you for asking your question.

DMS has limitation on auto_increment as described in the document.

The AUTO_INCREMENT attribute on a column isn't migrated to a target database column.

To upgrade to RDS MySQL8.0 from RDS MySQL5.7, we have several option, in-place[1], snapshot/restore, and Amazon RDS Blue/Green Deployments[2].

For more information, please see AWS database blog Best practices for using a MySQL read replica to upgrade an Amazon RDS for MySQL database

[1] https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_UpgradeDBInstance.MySQL.html#USER_UpgradeDBInstance.MySQL.Major / https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL.Procedural.Importing.External.Repl.html

[2] https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/blue-green-deployments-overview.html

I hope this might help.

Hi, I'd suggest to use AWS DMS with MySQL as source: see https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.MySQL.html

DMS will provide you with lots of flexibility in this migration via transformation rules, etc.
Also, if you use its CDC feature, you can create the new version in parallel of the current one and get it updated in quasi real-time to see how it behaves.

See https://aws.amazon.com/dms/features/ for all available features

Best,

Didier