Fine-tune SQL Server to Aurora PostgreSQL conversions with AWS Transform and Kiro
Microsoft Workloads on AWS Blog
This article demonstrates how to resolve complex SQL Server objects flagged by AWS Transform for human review during migration to Aurora PostgreSQL using Kiro IDE and the AWS Transform MCP server.
- AWS Transform automatically converts standard database objects but flags complex ones like stored procedures with proprietary Transact-SQL for human validation
- Use Kiro IDE with AWS Transform MCP server to fetch converted artifacts, fix issues locally with full code context, and iterate without multiple AWS Transform passes
- AWS Transform assigns severity levels (Critical, High, Medium, Low) to issues and grades schema readiness as Not Ready, Conditional, or Ready for Production
- Six-step workflow: install MCP server in Kiro, get IDE prompt from AWS Transform console, authenticate, review handoff summary, approve and upload fixes, deploy corrected schema
- Kiro can autonomously fix issues or require per-fix approval; revalidation shows compatibility improvements before final Aurora PostgreSQL deployment
- MCP is an open standard connecting AI assistants to external tools, allowing any compatible IDE to work with AWS Transform
This approach accelerates SQL Server modernization by enabling developers to resolve complex conversion issues in their local IDE with AI assistance while maintaining validation rigor.
The AWS News Feed is currently looking for gold sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.
Related articles
2026
2026
2026
2025
The AWS News Feed is currently looking for silver sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.