Migrating Oracle Databases to Amazon Aurora

1 2018 Amazon Web services , Inc. or its Affiliates. All rights Layton,Business Development, database , AWS APACM igrating Oracle Databases to Amazon Aurora 2018 Amazon Web services , Inc. or its Affiliates. All rights to Migrate Databases to AWS? 2018 Amazon Web services , Inc. or its Affiliates. All rights Want to Migrate to AWS, They can t afford long periods of application downtime Tools that enable minimal downtime are expensive It seems too complex and expensive to migrate They still need a copy of the data on-premises They want to migrate to an open source database Sending large volumes of data to AWS requires an expensive international network link They don t have the skills inside their organization 2018 Amazon Web services , Inc.

2 Or its Affiliates. All rights Approach to Migrate to your AWS your Virtual Private Cloud (VPC) in to AWS with a VPN or Direct and backup your the backup to an EC2 instance with the DB the EC2 instances for the the users to use AWS 2018 Amazon Web services , Inc. or its Affiliates. All rights Approach to Migrate to your AWS your Virtual Private Cloud (VPC) in to AWS with a VPN or Direct and backup your the backup to an EC2 instance with the DB the EC2 instances for the the users to use AWSS teps 4-9 could take a week or more! 2018 Amazon Web services , Inc. or its Affiliates. All rights There is a Better Way! 2018 Amazon Web services , Inc. or its Affiliates.

3 All rights database Migration Service (AWS DMS)DMS migrates Databases to AWS easily and securely with minimal downtime. It can migrate your data to and from most widely used commercial and open-source AuroraDynamoDBS3 Bucket 2018 Amazon Web services , Inc. or its Affiliates. All rights Schema Conversion Tool (AWS SCT)SCT helps automate many database schema and code conversion tasks when Migrating between database engines or data warehouse enginesAmazon Aurora 2018 Amazon Web services , Inc. or its Affiliates. All rights Migration the Easier WayStep 1: Convert or copy your schemaSource DB or DWAWS SCTN ative toolDestination DB or DWStep 2: Move your dataSource DB or DWAWS SCTD estination DB or DWAWS DMS 2018 Amazon Web services , Inc.

4 Or its Affiliates. All rights Does DMS Work? 2018 Amazon Web services , Inc. or its Affiliates. All rights Databases for DMSOn-premises, Cloud and Amazon EC2 instance Databases : Oracle database 10g 12c Microsoft SQL Server 2005 2017 Azure SQL database (CDC operations are not supported) Db2 LUW versions Fix Pack 1, version , and version Db2 LUW version with Fix Pack 5 is not supported. MySQL MariaDB (MySQL-compatible data source) PostgreSQL + SAP ASE + MongoDB +RDS instance Databases : Oracle database 11g 12c Microsoft SQL Server 2008R2 2017 MySQL versions MariaDB (MySQL-compatible data source) PostgreSQL +. CDC only on +, +, +, 10+ Amazon Aurora (MySQL-compatible data source) Amazon S3 2018 Amazon Web services , Inc.

5 Or its Affiliates. All rights Databases for DMSOn-premises and EC2 instance Databases : Oracle database 10g 12c Microsoft SQL Server 2005 2016 MySQL MariaDB (MySQL-compatible data source) PostgreSQL + SAP ASE 15+RDS instance Databases : Oracle database 11g 12c Microsoft SQL Server 2008 R2 -2017 MySQL MariaDB (MySQL-compatible data source) PostgreSQL + Amazon Aurora (MySQL-compatible and PostgreSQL-compatible data source) Amazon Redshift, Amazon DynamoDB, Amazon S3 2018 Amazon Web services , Inc. or its Affiliates. All rights UsersAWSI nternetKeep Your Apps Running During the MigrationStart a replication instanceConnect to source and target databasesSelect tables, schemas, or databasesLet AWS DMS create tables, load data, and keep them in syncSwitch applications over to the target at your convenienceAWSD atabase Migration ServiceVPN 2018 Amazon Web services , Inc.

6 Or its Affiliates. All rights less than $10 per TB! 2018 Amazon Web services , Inc. or its Affiliates. All rights Schema Conversion Tool (AWS SCT)SCT helps automate many database schema and code conversion tasks when Migrating between database engines or data warehouse enginesAmazon Aurora 2018 Amazon Web services , Inc. or its Affiliates. All rights Helps with Converting Tables, Views & CodeSequencesUser-Defined TypesSynonymsPackagesStored ProceduresFunctionsTriggersSchemasTables IndexesViewsSort and distribution keys 2018 Amazon Web services , Inc. or its Affiliates. All rights can tell you how hard the migration will be1. Connect SCT to Source and Target Run Assessment Read Executive Follow detailed instructions.

7 2018 Amazon Web services , Inc. or its Affiliates. All rights and Terms and Conditions$0for software licenseAllowed Use Use SCT to migrate database schemas to Amazon RDS, Amazon Redshift, or Amazon EC2-based Databases To use SCT to migrate schemas to other destinations, contact for special pricingPricing Free software license For active AWS customers with accounts in good standing 2018 Amazon Web services , Inc. or its Affiliates. All rights to use DMS and SCT? 2018 Amazon Web services , Inc. or its Affiliates. All rights for Migration Project PhasesPhaseService/ToolNotesAssessmentAW S Schema Conversion ToolReports on the database objects, complexity and types of migration issuesSchema MigrationAWS Schema Conversion ToolCopies a schema or migrates a schema depending on whether it is a homogeneous or heterogeneous migrationsData MigrationAWS database Migration ServiceAWS Schema Conversion ToolBulk load and change data capture (CDC)

8 OptionsExtraction and load for large data warehouses, including AWS Snowball integrationApplication MigrationAWS Schema Conversion ToolSQL statement migration in application codeData ValidationAWS database Migration ServiceEnsure data is the same on source and targetFunctional TestingVarious Tools on MarketplaceEnsure the application runs as intendedPerformance TestingVarious Tools on MarketplaceEnsure the application performance as intended 2018 Amazon Web services , Inc. or its Affiliates. All rights for Migration ScenariosScenarioExampleRecommendationHo mogeneous migration to the same database version and editionMigration of Oracle database 11gR2 Enterprise Edition from on-premises to EC2 Use the native replication technology to create a standby database and then failover to the standby databaseHomogeneous migration to a different versionMigration of Oracle 11gR2 to Oracle 12cAWS Schema Conversion Tool and AWS database Migration ServiceHomogeneous migration to a different editionMigration of Oracle Enterprise Edition to Standard EditionAWS Schema Conversion Tool and AWS database Migration ServiceHeterogeneous migrationMigration from Oracle database to PostgreSQLAWS Schema

9 Conversion Tool and AWS database Migration Service 2018 Amazon Web services , Inc. or its Affiliates. All rights Target Amazon Aurora 2018 Amazon Web services , Inc. or its Affiliates. All rights is Amazon Aurora ? database reimagined for the cloud Speedandavailabilityof high-end commercial Databases Simplicityandcost-effectivenessof open source Databases Drop-in compatibilitywith MySQL and PostgreSQL Simple pay as you gopricingDelivered as a managedservice 2018 Amazon Web services , Inc. or its Affiliates. All rights the relational database123 Scale-out, distributed architectureService-oriented architecture leveraging AWS servicesAutomate administrative tasks fully managed service 2018 Amazon Web services , Inc.

10 Or its Affiliates. All rights , distributed architecture Purpose-built log-structured distributed storage system designed for Databases Storage volume is striped across hundreds of storage nodes distributed over 3 different availability zones Six copies of data, two copies in each availability zone to protect against AZ+1 failures Plan to apply same principles to other layers of the stackMasterReplicaAvailability Zone 1 Shared storage volumeAvailability Zone 2 Availability Zone 3 Storage nodes with SSDsSQLT ransactionsCachingSQLT ransactionsCachingSQLT ransactionsCaching 2018 Amazon Web services , Inc. or its Affiliates. All rights more throughput than MySQL; 3x more than PostgreSQL 2018 Amazon Web services , Inc.