How to enable SQL Server modernization capabilities - AWS Transform

Question

Hi all,
I wanted to test AWS Transform for SQL Server modernization, doing myself a lab following what is demoed in this article
https://aws.amazon.com/transform/windows/sql-server/?sc_channel=sm&sc_campaign=Support&sc_publisher=YOUTUBE&sc_country=global&sc_geo=GLOBAL&sc_outcome=AWS%20Support&sc_content=Support&trk=Support&linkId=900380150
I setup my environment and wanted to create a job for Windows Modernization - SQL Server modernization .. but since SQL Server modernization was not visible the response was:

Based on the available job types for your account, SQL Server modernization is not currently available. Here are the transformation job types you can work with:

1. Framework Migration - Migrate applications to newer framework versions
2. Runtime Upgrade - Upgrade application runtimes to newer versions
3. Custom Transformation - Track execution of custom transformations using AWS Transform CLI
4. API Upgrade - Update API calls and SDK implementations
5. Assessment - Generate migration assessments from on-premises data
6. .NET Modernization - Modernize .NET applications
.7 VMware Migration - Migrate VMware workloads to AWS
8. Mainframe Modernization - Modernize mainframe applications

If you need SQL Server modernization capabilities, I recommend contacting your AWS account team to discuss enabling additional job types for your account.

So what should I do to enable SQL Server modernization capabilities?

I am using AWS Transform deployed in eu-central-1 Europe(Frankfurt)

Thanks in advance

p.s. There are no available tags for either SQL Server modernization or Windows modernization!

Yashwant Srivastava · Accepted Answer

The SQL server modernization is not available in any other region other than us-east-1.
The same applies to Experience-based Acceleration and Custom/Code(My Custom Transformations, Framework Migration, Runtime version upgrade, API/SDK upgrade).
If you really need the feature then use us-east-1 as discovery region with database cloned in this region and use your target region as any other region.
For more information check the user guide:
https://docs.aws.amazon.com/transform/latest/userguide/sql-server-modernization.html#supported-regions

re:Post Agent · Answer

To enable SQL Server modernization capabilities in AWS Transform, you need to follow these steps:

1. First, ensure your .NET applications are compatible with the service requirements. AWS Transform for SQL Server modernization only supports .NET Core 6+ applications. If your application uses .NET Framework 4.x or earlier versions, you must first upgrade to .NET Core 6+ using AWS Transform for .NET modernization before you can use the SQL Server transformation capabilities.

2. Access the AWS Transform console in the eu-central-1 region.

3. Create a new modernization job by selecting "Create modernization job."

4. Select "Windows modernization" job type and then "SQL Server modernization."

5. Enter the required job details:
- Job name (use a descriptive name for your project)
- Optional description
- Target region (ensure this matches your SQL Server location)

6. Choose "Create job" to proceed.

If SQL Server modernization is still not visible as an option in your account, you should contact your AWS account team to request enabling this capability for your account. It appears that not all AWS Transform job types are automatically available to all accounts, and SQL Server modernization may need to be specifically enabled for your account.

Once enabled, you'll need to configure database connectors to establish secure connectivity to your SQL Server databases. This will allow AWS Transform to access your database schemas and metadata for assessment and conversion.  
**Sources**  
[Full-stack Windows modernization - AWS Transform](https://docs.aws.amazon.com/transform/latest/userguide/windows-full-stack.html)  
[SQL Server modernization workflow - AWS Transform](https://docs.aws.amazon.com/transform/latest/userguide/sql-server-modernization-workflow.html)  
[SQL Server modernization - AWS Transform](https://docs.aws.amazon.com/transform/latest/userguide/sql-server-modernization.html)  
[AWS Transform setup - AWS Transform](https://docs.aws.amazon.com/transform/latest/userguide/sql-server-transform-setup.html)

How to enable SQL Server modernization capabilities - AWS Transform

Add your answer

Relevant content