OFICIAL AWS What's New

AWS Transform for full-stack Windows modernization now supports offline schema transformation to Aurora PostgreSQL

What happened
Based on AWS What's New · Aug 03, 2026

AWS Transform now supports offline schema conversion for SQL Server to Aurora PostgreSQL, allowing enterprises to modernize legacy .NET applications without a live database connection.

🚩 Report a correction ↗ Open source
Key points
·
Today, AWS Transform for full-stack Windows modernization details general availability of offline source transformation, enabling customers to modernize Microsoft SQL Server databases to Amazon Aurora PostgreSQL without requiring a live database connection.
·
AWS Transform now converts SQL Server storage objects, powered by AWS DMS, and code objects (stored procedures) using an agentic, interactive experience.
·
Enterprises modernizing legacy.NET applications and their dependent SQL Server databases can now start their modernization by directly uploading the Data Design Language (DDL) source files from their databases.
·
With offline source transformation, customers upload SQL Server data design language (DDL) files, assess database and stored procedure complexity, and generate a customizable transformation plan.

AWS Transform for full-stack Windows modernization has introduced general availability of offline source transformation, enabling customers to convert Microsoft SQL Server databases to Amazon Aurora PostgreSQL without requiring a live database connection. The feature leverages AWS Database Migration Service (DMS) to transform storage objects and uses an agent-based interactive process for code objects like stored procedures. Enterprises can upload Data Design Language (DDL) source files directly to begin the modernization process, bypassing the need for an active database connection.

The offline transformation workflow allows customers to assess database and stored procedure complexity before generating a customizable conversion plan. AWS Transform converts tables, schemas, and code objects such as stored procedures and functions, validates functional equivalence, and deploys the converted schema to Aurora PostgreSQL. This process ensures that the target database maintains compatibility with the original SQL Server structure while enabling migration to a PostgreSQL-compatible environment.

For .NET applications dependent on the SQL Server database, AWS Transform updates connection strings, ADO.NET, and Entity Framework data-access calls to ensure PostgreSQL compatibility. Customers can address remaining conversion issues either through the web console or by using the AWS Transform MCP server to integrate with their preferred IDE. A separate synthetic data workflow is also available to populate Aurora PostgreSQL with test data for end-to-end application validation.

The new offline source transformation feature is available in the AWS US East (N. Virginia) region. Customers can access the AWS Transform product page or review the documentation for full-stack Windows modernization to begin the migration process. The feature aims to simplify and accelerate the modernization of legacy Windows applications to a cloud-native PostgreSQL environment.

Original source → Deals on Clipraptor.com →