AWS allows you to migrate your data to and from most widely used commercial and open-source databases such as Oracle, PostgreSQL, Microsoft SQL Server, Amazon Redshift, Amazon Aurora, MariaDB, and MySQL.
- homogeneous migrations such as Oracle to Oracle, and also
- heterogeneous migrations between different database platforms, such as:
- Oracle to MySQL or
- MySQL to Amazon Aurora MySQL-Compatible Edition.
AWS schema tool SCT (Schema Conversion Tool) doesn’t allow yet a direct schema conversion :
- From Oracle Database
- To RDS - SQL Server
Microsoft on its side, has an equivalent tool for database migration which name is DSCT - Microsoft Database Schema Conversion Toolkit.
As Microsoft tool DSCT is free (AWS SCT is also free), you can use the following workaround/tips:
If the target of database of the schema conversion is SQL Server, any schema generated compatible with SQL Server will work whatever the tools you have used to generate the schema (AWS SCT, or Microsoft DSCT)
As AWS doesn't support this kind of schema conversion (Oracle to SQL Server) with AWS SCT, you can use the Microsoft tool DSCT to generate the SQL Server schema. (Microsoft tool DSCT is included in the freeware SSMA - which stands for SQL Server Migration Assistant).
Once the schema is converted from Oracle to SQL Server using Microsoft tool’s DSCT, review the generated T-SQL code, test it and validate it.
Afterwards this schema conversion step, you can continue with AWS database migration methodology by integrating the converted schema in AWS migration steps’.
For Oracle to SQL Server migration you can use Microsoft's own "SQL Server Migration Assistant for Oracle":
- Accepted Answerasked a year ago
- AWS OFFICIALUpdated 4 months ago
- AWS OFFICIALUpdated 2 months ago
- AWS OFFICIALUpdated 3 months ago
- How do I move SQL Server users from one RDS for SQL Server instance to another or to an on-premises environment from RDS?AWS OFFICIALUpdated 6 months ago
- EXPERTpublished 7 months ago
- EXPERTpublished 6 months ago