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.
0
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.
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.
1 Answers
1
Hello,
For Oracle to SQL Server migration you can use Microsoft's own "SQL Server Migration Assistant for Oracle":
answered 10 days ago
Relevant questions
Is it possible to use AWS RDS SQL Server as an AAG target from on premise primary?
asked 7 months agoWhat's a MS SQL "named instance" ?
Accepted AnswerOracle Active Data Guard on AWS
Accepted Answerasked 3 years agoHow 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.
asked 13 days agoOracle licensing: What did your customers do?
Accepted Answerasked 4 years agoError loading metadata using AWS SCT against an RDS SQL Server Instance
asked 5 months agoAnnouncement: 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
asked a month agoCloudEndure RTO for Oracle and E-Business Suite
Accepted Answerasked 2 years agoError while connecting to SQL Server Express Edition from SCT
asked 10 months agoLooking for guidance/documentation to migration Oracle Fusion Middleware applications from Oracle Cloud to AWS
asked 4 months ago