AWS DMS Schema Conversion now uses generative AI

Posted on: Dec 1, 2024

AWS Database Migration Service (AWS DMS) Schema Conversion with generative AI is now available. The feature is currently available for database schema conversion from commercial engines, such as Microsoft SQL Server, to Amazon Aurora PostgreSQL-Compatible Edition and Amazon Relational Database Service (Amazon RDS) for PostgreSQL.

Using generative AI recommendations, you can simplify and accelerate your database migration projects, particularly when converting complex code objects which typically require manual conversion, such as stored procedures, functions, or triggers. AWS DMS Schema Conversion with generative AI converts up to 90% of your schema.

AWS DMS Schema Conversion with generative AI is currently available in three AWS Regions: US East (N. Virginia), US West (Oregon), and Europe (Frankfurt).

You can use this feature in the AWS Management Console or AWS Command Line Interface (AWS CLI) by selecting a commercial database such as Microsoft SQL Server as your source database and Amazon Aurora PostgreSQL or Amazon RDS for PostgreSQL as your target when initiating a schema conversion project. When converting applicable objects, you will see an option to enable generative AI for conversion. To get started, visit the AWS DMS Schema Conversion User Guide and check out this blog post.