Oracle to SQL Server Migration - Exploring the process

Recently, one of my friends asked me whether I have done migration from Oracle to SQL Server. 

I replied him I did that some time back. 

His next question was, “Did you do from beginning to end?”

This question sparked a thought in me to try this out with an AWS EC2, as I could remember more of data migration and less of object migration. 

As the most recent version of Oracle should have lot more schema objects to migrate, so I thought it will be worth to give a try!  

I launched an Oracle 19c Enterprise EC2 in minutes with few steps as below. 

Spin up an EC2 with Oracle

• Login into your AWS account.

• From Services menu on the left, select EC2.

• Select Launch Instances

• Search for Oracle in AMI selection screen

• From marketplace, you will see and select:

• Select medium size from t2 family of instance types, so the instance is not too slow.

• Configure instance details with basic Network and Subnet details with all other default options.

• Accept provided storage of 127GiB. Add tags.

• In security group, allow TCP with port 5521 and SSH with port 22 for your laptop/desktop IP.

• Review and Launch

• Update host file at C:\Windows\System32\drivers\etc with public IP address and private DNS name of this EC2 instance.

• Update tnsnames.ora in your local folder where you installed Oracle Instant Client with the public IP of EC2 instance and hostname 

• Allow your laptop/desktop IP to talk to this EC2 instance with iptables command

Now I was able to connect to the Oracle instance with SSH.

However, when I wanted to setup an ODBC Data source to this Oracle instance, I was stuck and my friend Ramesh helped me with that. That was a milestone for me in this exploration to have this DSN working!

Will add another article on my next steps….

Best.