Posted On: Jun 5, 2024
Amazon Database Migration Service (Amazon DMS) now supports Babelfish for Aurora PostgreSQL as a source by enhancing its existing PostgreSQL endpoint to handle Babelfish data types. This support is available in the Amazon Web Services China (Beijing) region, operated by Sinnet, and the Amazon Web Services China (Ningxia) region, operated by NWCD. Babelfish is a feature of Amazon Aurora PostgreSQL-Compatible Edition that enables Aurora to understand commands from applications written for Microsoft SQL Server.
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 DMS console, CLI, or SDKs. To learn more, refer to using Babelfish for Aurora PostgreSQL as a source for Amazon DMS.