AWS Transform for full-stack Windows modernization now supports offline schema transformation to Aurora PostgreSQL
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.
The useful question is what changes for users, developers or buyers, and whether the announcement stays industry context or becomes something people can actually use.
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.