asked on

How move an application to EC2

I have an on-premise windows application running on a windows server and uses an oracle database running on RHEL server. The database is only used internally by application and does not store user data.

I want to migrate the windows application to an existing EC2 windows server in AWS, and the existing oracle database to a schema in an

exisitng RDS service in AWS.

My thinking is that I can *not* use AWS SMS (Server migration service) or AMS (Application migration service) to move the server in this case because that normally involves creating an VM image

of the machine which include the Windows O/S and creating the EC2 machine using that AMI.

Is the only way to do this migration is to reinstall the windows application on the existing EC2 windows machine and creating a new database schema in the RDS database?

ASKER CERTIFIED SOLUTION

Mlanda T

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

slightwv (䄆 Netminder)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

sam15

ASKER

i was planning to use datapump for oracle data as it is 10 times faster than exp/imp which i thought they stopped supporting. with RDS you must move the file from S3 to RDS anyway. I don't think exp/imp has any advantage here, You cant import direct from S3 bucket.

Do SMS and AMS create an Amazon AMI which seems to be similar to a VM image export file that you use to create the EC2 with then EC2 will be an exact block level copy of on-premise machine in AWS/EC2? Dont you have to change IP addresses later?

slightwv (䄆 Netminder)

>>as it is 10 times faster

You have personally tested this or just gone by what is on the internet?

From database to database server disk, it is probably faster. But then what? You rarely want the file on the database server.

Write down your steps to get the data from on-prem to RDS using datapump.

Then compare it to classic. Here, I'll do that one for you:
1: Log into PC.
2: run exp from CMD prompt
3: run imp from CMD prompt

>>Do SMS and AMS create

Don't know those products.

sam15

ASKER

I have not tested it personally but i have a book that did that and shows it is way much faster.
https://oracle-base.com/articles/10g/oracle-data-pump-10g

slightwv (䄆 Netminder)

I too have read those same articles. I've also read the reasons it can make that claim.

However, there are WAY TOO MANY variables involved.

For example: size of the database. If you have a 100G database, does it matter datapump is 2 minutes faster? Yes, that 2 minutes is completely made up for the argument but you get the idea.

Compare the complexity of using datapump to do what you want to do vs classic. Then take the total time not just the speed of the datapump steps.

I'm still waiting for the steps involved for you to use datapump to move data from on-prem to AWS.

sam15

ASKER

When you generate an AMI for an on-premise machine using SMS, do you include the oracle data files in case there are 500 GB - 1 TB of files sizes or SMS will allow you to include O/S and applications only and then copy data files separately to EBS volume.

slightwv (䄆 Netminder)

Again, don't know SMS.