How to migrate DB on premise Oracle to Microsoft SQL Server DB in AWS. We see SCT will not allow MS SQL Server as Target when source is Oracle. Looking for tools like SCT to move Schema from Oracle.

Question

We see SCT is useful to move Source Schema (Eg: Oracle ) to Target Schema DB (Eg: Aurora Postgres) and other limited DB combinations. Now requirement is to migrate from On-premise Oracle to MS SQL Server in AWS Cloud.  Please let me know if anyone has worked on this task.

Answer

Hello,

For Oracle to SQL Server migration you can use Microsoft's own "SQL Server Migration Assistant for Oracle":

[https://docs.microsoft.com/en-us/sql/ssma/oracle/migrating-oracle-databases-to-sql-server-oracletosql?view=sql-server-ver15]()

How to migrate DB on premise Oracle to Microsoft SQL Server DB in AWS. We see SCT will not allow MS SQL Server as Target when source is Oracle. Looking for tools like SCT to move Schema from Oracle.

Relevant questions

Is it possible to use AWS RDS SQL Server as an AAG target from on premise primary?

What's a MS SQL "named instance" ?

Oracle Active Data Guard on AWS

How to migrate DB on premise Oracle to Microsoft SQL Server DB in AWS. We see SCT will not allow MS SQL Server as Target when source is Oracle. Looking for tools like SCT to move Schema from Oracle.

Oracle licensing: What did your customers do?

Error loading metadata using AWS SCT against an RDS SQL Server Instance

Announcement: Amazon RDS for Oracle - End of Support Timeline for 12c Oracle Release 2 (12.2.0.1) and Oracle Release 1 (12.1.0.2) Major Version

CloudEndure RTO for Oracle and E-Business Suite

Error while connecting to SQL Server Express Edition from SCT

Looking for guidance/documentation to migration Oracle Fusion Middleware applications from Oracle Cloud to AWS