- Migration and Modernization›
- AWS Transform›
- SQL Server
AWS Transform for SQL Server modernization
The first agentic AI service for modernizing SQL Server databases at scale
Accelerate SQL Server database modernization with agentic AI
AWS Transform accelerates SQL Server to Amazon Aurora PostgreSQL modernization by up to 5x through intelligent schema conversion, stored procedure transformation, and coordinated application refactoring. With the specialized database modernization agent, teams can execute comprehensive database modernization projects with consistency, reduce operating costs by up to 70% by moving away from costly licenses, and ensure application compatibility.
Database teams use a unified web experience through natural language interaction with the domain-expert agent specialized in database modernization. Under user supervision, the agent analyzes SQL Server databases and dependent applications and proposes coordinated modernization plans. Upon approval, it converts schemas, transforms stored procedures, migrates data, and refactors application code—providing continuous updates and comprehensive transformation summaries with maintained application functionality.
Benefits
Transform SQL Server schemas, stored procedures, functions, and triggers to Aurora PostgreSQL automatically. Reduce weeks of manual analysis and conversion work while ensuring compatibility and maintaining business logic integrity.
Automatically discover and refactor .NET applications that depend on your SQL Server databases. Update Entity Framework, ADO.NET configurations, connection strings, and embedded SQL to work with Aurora PostgreSQL without breaking application functionality.
Modernize hundreds of interconnected SQL Server databases and .NET applications in coordinated waves. Automatically map dependencies between databases and applications, then execute transformations in the correct sequence to minimize business disruption.
Move away from costly SQL Server licensing fees while cutting overall modernization project costs. Transition to open-source Aurora PostgreSQL and reduce both operational expenses and transformation effort through agentic AI-driven automation.
End-to-end database modernization automation
Comprehensive database and application discovery
AWS Transform uses deep domain expertise in SQL Server and Aurora PostgreSQL technologies, leveraging intelligence from Amazon Bedrock large language models (LLMs) for optimal database analysis. Through expanded connector support, the agent enables integration from GitHub, Bitbucket, and GitLab for database schema analysis and dependent application assessment. The agent analyzes complete database ecosystems to identify SQL Server versions, schema complexity, stored procedure dependencies, application coupling patterns, and cross-system dependencies, providing comprehensive pre-transformation assessment reports. Based on database environments, dependencies, and stated modernization objectives, the specialized agent delivers tailored transformation plans and recommendations.
Coordinated database and application modernization
The specialized agent supports transforming SQL Server databases to Aurora PostgreSQL, including intelligent stored procedure conversion, schema conversion, and coordinated application refactoring. It offers integrated transformation with dependency management and handles complex database objects, reducing manual work required for comprehensive database modernization. The agent transforms databases using secure, network-isolated environments and iteratively resolves issues across database and application layers. Upon completion, the agent commits converted schemas, transformed stored procedures, migrated data, and refactored application code to new branches, preserving original implementations.
Comprehensive verification and quality assurance
The specialized agent autonomously verifies transformation quality across database schemas, stored procedure compatibility, data migration accuracy, and application functionality upon successful transformation. It generates comprehensive transformation summaries that document all changes made across database objects, stored procedure conversions, data migration results, and application code modifications. Plus, it identifies any issues requiring review. Teams receive detailed reports with explanations of transformation decisions and recommendations for optimization—all with human reviews and approvals before deployment.
Database deployment and application integration
The specialized agent generates production-ready database deployment scripts and application configuration templates based on transformed databases and target Aurora PostgreSQL environments. It coordinates database deployment with application updates, providing comprehensive deployment documentation and validation procedures. The agent enables teams to validate modernized databases in cloud environments and establish automated deployment processes with appropriate oversight.
Explore AWS Transform for SQL Server modernization at your own pace
Try out the interactive demo experience to see AWS Transform in action.
Teamfront
"Our initial success with AWS Transform—modernizing 800K lines of code in just two weeks—demonstrated that we could transform massive codebases in weeks instead of months. This breakthrough showed us a clear path to retiring technical debt and gave us the confidence to expand our modernization efforts. We're now moving from SQL Server to PostgreSQL while simultaneously transforming our applications, accelerating our modernization journey and enabling us to better serve our portfolio of field service software companies."
Bobby Land, Chief Product and Technology Officer, Teamfront
Verisk
"Modernizing our SQL Server infrastructure has been a top priority, but the complexity and risk of migrating mission-critical databases has been a significant barrier, AWS Transform provides us with the automated assessment and transformation tools we need to confidently migrate to modern, open-source Postgres database engines. We estimate this will reduce our database licensing costs by 40% while accelerating our modernization timeline by up to 4x"
Cándido Alcaide Fernández, Chief Technology Officer, Verisk Specialty Business Solutions
Xilnex
"As we scale our POS platform across multiple markets, modernizing from SQL Server to PostgreSQL with AWS Transform represents a strategic opportunity to reduce our infrastructure costs while improving system performance for our customers."
Eng Aik Kian, Chief Technology Officer, Xilnex
