I want to Migrate from Oracle RDBMS to AWS S3 using Kinesis

+1 vote

Following are the itineraries

  1. Is there way to  automate first full load so that it creates different streams for different tables.
  2. In case if there is a new additional table, how do I create a new stream automatically. 3.How do I load to Kinesis incrementally

Please help

Apr 20, 2018 in Cloud Computing by brat_1
• 7,200 points
2,390 views

2 answers to this question.

+1 vote

Try to understand AWS Schema Conversion Tool (AWS SCT) and its Database Migration Service (AWS DMS). DMS does not necessarily use Kinesis but it is specifically design for this use case.

Refer this to start: https://aws.amazon.com/blogs/database/how-to-migrate-your-oracle-data-warehouse-to-amazon-redshift-using-aws-sct-and-aws-dms/

answered Apr 20, 2018 by hemant
• 5,790 points
0 votes

AWS Database Migration Service (AWS DMS) helps you migrate databases to AWS easily and securely. The AWS Database Migration Service can migrate your data to and from most widely used commercial and open-source databases. The service supports homogenous migrations such as Oracle to Oracle. It also supports heterogeneous migrations between different database platforms, such as Oracle to Amazon Aurora or Microsoft SQL Server to MySQL. The source database remains fully operational during the migration, minimizing downtime to applications that rely on the database.
For more
details you can view the following link:-

https://aws.amazon.com/blogs/database/migrating-oracle-database-from-on-premises-or-amazon-ec2-instances-to-amazon-redshift/

answered Aug 16, 2018 by Priyaj
• 58,100 points

Related Questions In Cloud Computing

0 votes
2 answers

Is there a way to copy AMI from one AWS account to another AWS account using boto?

You could share the AMI from one ...READ MORE

answered Aug 21, 2018 in Cloud Computing by Priyaj
• 58,100 points
2,131 views
+8 votes
3 answers

How to download folder from AWS S3?

To Download using AWS S3 CLI : aws ...READ MORE

answered Sep 7, 2018 in Cloud Computing by eatcodesleeprepeat
• 4,710 points
287,421 views
0 votes
1 answer

How to delete the files from AWS S3 except the recently 5 added/updated files?

Use AWS s3 rm command with multiple --exclude options as shown: aws ...READ MORE

answered Jul 30, 2018 in Cloud Computing by Gopalan
• 1,360 points
3,791 views
+4 votes
2 answers

How come AWS S3 is erasing my extension from PDF files?

I think the problem should be with ...READ MORE

answered Mar 27, 2018 in Cloud Computing by code_ninja
• 6,300 points
3,898 views
+2 votes
2 answers

Can I run 'manage.py' from AWS EB Linux instance

You can refer to this documentation :- https://docs.aws.amazon.com/el ...READ MORE

answered Aug 17, 2018 in Cloud Computing by Priyaj
• 58,100 points
1,609 views
0 votes
3 answers

Using EC2 instance to access S3 bucket locally

You can use the boto library to ...READ MORE

answered Nov 30, 2018 in Cloud Computing by Aniket
3,290 views
0 votes
1 answer

Is there a way to transfer files between AWS s3 and ec2

The answer is a definite yes yes. ...READ MORE

answered Apr 17, 2018 in Cloud Computing by brat_1
• 7,200 points
788 views
0 votes
2 answers

How can I route request to EC2 instance behind AWS ELB?

You can have a look at the ...READ MORE

answered Aug 17, 2018 in Cloud Computing by Priyaj
• 58,100 points
1,033 views
+3 votes
5 answers

AWS EFS vs EBS vs S3 (differences & when to use?)

EFS is: May not yet be available in ...READ MORE

answered Apr 9, 2018 in Cloud Computing by hemant
• 5,790 points
4,781 views
+2 votes
2 answers

Is there a way to add cache control in AWS S3?

use of  current upstream master branch will ...READ MORE

answered Apr 10, 2018 in Cloud Computing by hemant
• 5,790 points
8,612 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP