Migrate from Aurora Serverless v1 Postgres to Aurora MySQL using DMS/STC

0

I'm confused on what the right service/tool to use to migrate my Aurora Serverless v1 PG to Aurora Serverless MySQL, I tried DMS but I found that I should do schema migration first. but DMS schema conversion doesn't support Aurora PG as a source.

I have found that there is a schema conversion tool (SCT), I'm tried it but I'm not able to connect to my Aroura PG.

Do SCT support migrating from Aurora PG to Arura MySQL? Or maybe I'm not on the right path?

1개 답변
1

SCT can automatically migrate most database schema objects like tables, indexes etc from a source to target database. It supports migrating from Aurora PostgreSQL.

A few things to check:

Make sure the IAM role used by SCT has necessary permissions to access both the source and target databases.

Verify connection details like endpoint, port, username, password etc. when connecting to the source Aurora PostgreSQL database.

The target database should be an empty Aurora MySQL database ready to receive the migrated schema.

You may need to manually migrate any database objects not supported automatically by SCT like stored procedures.

Refer AWS documentation for step-by-step guide to use SCT - https://docs.aws.amazon.com/schema-conversion-tool/latest/userguide/CHAP_GettingStarted.html

profile picture
전문가
답변함 2달 전
  • Thanks for the help, I forget to clarify it is Aroura Serverless, where I found that it is not accessible from outside VPC! There is a solution to use an EC2 instance in the middle and connect to t he EC2 using SSH tunnel. But I can't find how to connect SCT using SSH!

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인