Does AWS SCT support RDS SQL Server?

0

Hi all, I'm wondering if AWS Schema Conversion Tool supports RDS for SQL Server Standard Edition as a source endpoint? The documentation says that it does not so wanted to check if anyone has tried this before? And what is the recommended target database engine to migrate to (RDS PostgreSQL or RDS MySQL) that will have the least amount of code refactoring?

Thanks!

2 Risposte
0

Are you looking to migrate from SQL Server to PostgreSQL or MySQL? You can explore Babelfish for Aurora PostgreSQL.

With Babelfish, Aurora PostgreSQL now understands Microsoft SQL Server's T-SQL, and supports the same communications protocol, so your apps that were originally written for SQL Server can now work with Aurora with fewer code changes.

The blog Migrate from SQL Server to Amazon Aurora using Babelfish provides an overview of the migration steps. More information in documentation

Documentation Using Microsoft SQL Server as a source for AWS SCT list RDS SQL Server as one of the possible sources

AWS
ESPERTO
Mike_L
con risposta 2 mesi fa
profile picture
ESPERTO
verificato 2 mesi fa
0

RDS SQL Server with standard edition is supported as source for AWS SCT. You can modernize the db objects using SCT to PostgreSQL. Documentation mentions about enterprise edition with respect to permissions to capture enterprise features enabled in source SQL Server.

AWS
con risposta 2 mesi fa
profile picture
ESPERTO
verificato 2 mesi fa

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande