SQL Server 2019 to Oracle 18c
POC migration from SQL Server 2019 to Oracle 18c XE database. The process described in here works as described barring the additional permission that the repository schema/ user need (create materialized view).
|GRANT CONNECT, RESOURCE, CREATE SESSION, CREATE VIEW, create materialized view TO demo_migration IDENTIFIED BY demo_migration;|
I migrated the sample database “AdventureWorks” to 18c XE and did not face many issues but again it was just a sample database. There were some objects that did not get migrated though and I will try to investigate of the cause later. In a real world scenario, there will be a lot of such objects and that is why it is important to analyze and be prepared to address such issues with manual efforts.
Check out the below video on how to migrate SQL Server 2019 database to Oracle.