Meet us at DASH by Datadog  | June 25‑26, 2024  |  North Javits, NYC
 — 
Set up a meeting. Set Up a Meeting
Contact Us
Thought Leadership

Database Migration from Oracle to Aurora

February 3, 2023

Basic Migration from Oracle to Aurora Utilizing AWS Database Migration Service

We will use the AWS Database Migration Service to perform the migration securely and quickly. The Source database remains intact and operational during the migration process, so the applications that rely on the original database will not be affected.

During the migration, DMS manages all the complexities of the migration process, such as automatically replicating data changes that occur in the source database during the migration process.

AWS Database Migration Service is a reliable, highly resilient, and self–healing service. Continually monitors source and target databases, network connectivity, and the replication instance. In case of interruption, it automatically restarts the process and continues the migration from where it stopped.

AWS Database Migration Service offers simplified functionality. No need to install any drivers or applications; in most cases, it does not require changes to the source database.

Migration

We will create an Oracle database and tables in it as a source database.

Then Create an Aurora MySQL database as the target for the migration.

Finally, we will use the Database migration wizard to perform such migration.

Oracle

Let us create the Source Oracle Database

oracle1

Since this is a POC, we use Dev/Test.

ora2ora3ora4ora5ora6ora7ora8ora9

MySQL

Target MySQL Database

ora10

Since this is a POC, we use Dev/Test.

ora11ora12ora13ora14ora15ora16ora17ora18

We have Source, and Target Databases created.

Now we connect to the Source DB endpoint.

ora19

Now we are connected to the source Database using Oracle SQL Developer.

We go to the worksheet editor and enter a SQL statement.

This will be the table we are about to migrate to MySQL using the Database Migration Service.

 

CREATE TABLE sample

(

sample_id NUMBER(10) NOT NULL,

sample_name varchar2(50) NOT NULL,

sample_qty varchar2(50)

);

ora20ora21

 

Replication Instance

Now on the Database migration service, we create a replication instance

ora22

Add a name for the replication instance.

ora23ora24ora25

Create a Database migration service source endpoint.

Since it is the source, we select Oracle as the source engine.

ora26ora27

Now we test the endpoint connection.

ora28

Click on create endpoint and select Target endpoint.

Then chose Aurora MySQL as the target engine.

ora29ora30ora31

Now we have the Source and Target Endpoints

ora32

Database Migration Task

We now create a Database migration task.

ora33ora34ora35

The database migration task runs; now it says Load complete and 100% progress.

ora36

Now we connect to the target endpoint using MySQL Workbench.

my

Let’s test the connection to the database

my2

We can see the SAMPLE table was successfully migrated under the ADMIN schema.

my3

Conclusion

We could migrate a database with almost no effort and zero downtime.

Data changes to the source database during the migration are continuously replicated to the target, allowing the source database to be fully operational during the migration process.

my4

AWS Database Migration Service supports homogeneous migrations, such as Oracle to Oracle, and heterogeneous migrations between different database platforms, such as Oracle or Microsoft SQL Server to Amazon Aurora.

AWS Database Migration Service is relatively low-cost since you only pay for the compute resources used during the migration process and any additional log storage. Migrating a terabyte-size database can be done for as little as $3 for homogeneous and heterogeneous migrations of any supported databases.

Related Insights

We are results-driven with a focus on providing customer service excellence

IO Connect Services is here to help you by offering high-quality cloud technology solutions.
Connect with us
®2024 IO Connect Services
Privacy PolicyCookie Policy
magnifiercrossmenuchevron-down
linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram