Database migration from SAP HANA to RDS sql

You're correct that AWS Database Migration Service (DMS) and AWS Schema Conversion Tool (SCT) don't currently support SAP HANA as a source database for migration to Amazon RDS for SQL Server or MySQL. This does present a challenge for direct migration paths.

For migrating from SAP HANA to RDS SQL Server, you would need to consider alternative approaches since the standard AWS migration tools don't support this source-target combination. While the sources don't provide a specific solution for HANA to RDS migrations, they do outline migration patterns for other SAP databases.

For SAP ASE (Adaptive Server Enterprise) to Amazon RDS for SQL Server migrations, AWS DMS can be used along with optional schema conversion tools like erwin Data Modeler or SAP PowerDesigner. This approach involves manually migrating the database schema or using a CASE tool, then using AWS DMS to transfer the data.

Given the lack of native AWS support for HANA as a source, you may need to explore:

• Manual schema conversion and data export/import processes
• Third-party migration tools that support HANA
• SAP's native export/import capabilities to extract data from HANA in a format that can be loaded into your target RDS database
• Custom ETL processes to transform and move the data

Unfortunately, without direct tool support, this migration will likely require more manual effort and potentially custom development work compared to migrations from supported source databases.
Sources
Migrate from SAP ASE to Amazon RDS for SQL Server using AWS DMS - AWS Prescriptive Guidance
AWS Schema Conversion Tool - Amazon Web Services