Migrate SQL Server to Oracle

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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s