使用AWS re:Post即您表示您同意 AWS re:Post 使用条款
AWS re:Postre:Post

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?

主题
迁移与现代化数据库分析
标签
AWS 数据库迁移服务PostgreSQLAmazon Relational Database ServiceAWS 架构转换工具 (AWS SCT)MySQL
语言
English
Hartha aloufi
已提问 2 个月前129 查看次数
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
专家
Giovanni Lauria
已回答 2 个月前
  • Hartha aloufi
    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!

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈，并能促进提问者的职业发展。

回答问题的准则

相关内容