AWS DMS now supports Babelfish for Aurora PostgreSQL as a source
AWS Database Migration Service (AWS DMS) now supports Babelfish for Aurora PostgreSQL as a source by enhancing its existing PostgreSQL endpoint to handle Babelfish data types. Babelfish is a feature of Amazon Aurora PostgreSQL-Compatible Edition that enables Aurora to understand commands from applications written for Microsoft SQL Server.
AWS DMS supports both Full Load and Change Data Capture (CDC) migration modes for Babelfish. Full Load migration copies all of the data from the source database and CDC copies only the data that has changed since the last migration.
To migrate your data from Babelfish, you can use the AWS DMS console, AWS CLI, or AWS SDKs. To learn more, refer to using Babelfish for Aurora PostgreSQL as a source for AWS DMS.