Migration of Oracle DB (on-premise) to AWS redshift DB (Cloud)

A.V.R.L Anji Prasad, Nagaratna P. Hegde

Abstract


“Migration of Oracle Db (On-permise) to AWS redshift DB (Cloud)†is one of the solution for Database Freedom Service initiated by AWS focused on accelerating enterprise migrations from commercial database engines (Oracle, SQL Server, Teradata etc.) to AWS native database services like Amazon Redshift, Amazon Aurora, Amazon DynamoDB and Amazon ElastiCache, their by saving overall cost spent by business in terms of database licenses.

The main objective of this project is to Assess and identify the challenges in migrating Oracle database to AWS redshift DB. Provide, implement and test the solution to overcome the challenges.


References


Oracle, Database Concepts, 2018

https://docs.oracle.com/en/database/oracle/oracle-database/12.2/cncpt/database-concepts.pdf

Oracle, Database Licensing Information User Manual, 2019

https://docs.oracle.com/en/database/oracle/oracle-database/12.2/dblic/database-licensing-information-user-manual.pdf

Amazon Web Services, Overview of Amazon Web Services, 2019

https://d1.awsstatic.com/whitepapers/aws-overview.pdf

Amazon Web Services, Database Solutions on AWS, 2019

https://d0.awsstatic.com/Marketplace/documents/AWSMP_Solution%20Overview_Database.PDF

Amazon Web Services, Amazon Redshift, 2019

https://docs.aws.amazon.com/redshift/latest/mgmt/redshift-mgmt.pdf

Amazon Web Services, AWS Schema Conversion Tool, 2019

https://docs.aws.amazon.com/SchemaConversionTool/latest/userguide/Schema-Conversion-Tool.pdf

Amazon Web Services, AWS Database Migration Service, 2019

https://docs.aws.amazon.com/dms/latest/userguide/dms-ug.pdf


Full Text: PDF [Full Text]

Refbacks

  • There are currently no refbacks.


Copyright © 2013, All rights reserved.| ijseat.com

Creative Commons License
International Journal of Science Engineering and Advance Technology is licensed under a Creative Commons Attribution 3.0 Unported License.Based on a work at IJSEat , Permissions beyond the scope of this license may be available at http://creativecommons.org/licenses/by/3.0/deed.en_GB.

Â