SQL Server requirements - AWS Transform
Database requirements

SQL Server requirements

Database requirements

Externally hosted databases

Databases hosted outside of AWS are supported. To use an externally hosted database, you must ensure network connectivity between the database and the AWS Transform service.

SSIS workloads

  • Limitation: SQL Server Integration Services (SSIS) transformation is not supported.

  • Workaround: Use AWS Glue or other ETL services for SSIS migration.

Linked servers

  • Limitation: External database connections via linked servers require human configuration.

  • Workaround: Reconfigure linked servers after migration or use alternative approaches such as database links or application-level integration.

Complex T-SQL patterns

  • Limitation: Some advanced T-SQL patterns may need human intervention.

  • Workaround: Use Amazon Kiro CLI for complex SQL conversions. AWS Transform flags these for review during the transformation process.