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,080 points
409 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,750 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
• 56,920 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
• 56,920 points
374 views
+3 votes
2 answers

How to download folder from AWS S3?

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

answered Sep 6, 2018 in Cloud Computing by eatcodesleeprepeat
• 4,670 points
5,714 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,260 points
161 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,220 points
137 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
• 56,920 points
197 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
686 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,080 points
64 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
• 56,920 points
122 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,750 points
1,542 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,750 points
1,165 views