How do I migrate databases from an RDS Oracle DB instance to an RDS MySQL DB instance using DMS?

How do I migrate databases from an RDS Oracle DB instance to an RDS MySQL DB instance using DMS?


[Music] on John a cloud support engineer here at the AWS in the office sometimes Costas asked me how to migrate their databases on hey WS I’d tell them that this can be done through the antivirus database migration service in this video I’m going to use the AWS DMS console wizard to complete a migration from Oracle RDS instance to a my sequel obvious instance keep in mind the DMS has many migration options both commercial and open source databases can be migrated to and from AWS such as Oracle my Siegel and Postgres sequel DMS supports homogeneous migrations such as Oracle to Oracle or heterogeneous migrations such as Oracle to Postgres or my sequel to your uncle let’s get started as you can see I’m logged in to the AWS management console I’m now going to go to the DMS dashboard to start off with choose crepe migration then choose next we need to create the replication instance the replication incidence runs on an Amazon ec2 instance in a V PC on the Amazon virtual private cloud service you need the replication instance to perform the database migration enter details including name for this demonstration of chosen replication instance – description as you can see replication instance – description instance class TMS tea to medium a V PC I’ll select the V PC I want multis a hazy believe not and publicly-accessible believed selected there is also the advanced tab this is to set values for network and encryption settings if needed in this case I will be accepting the defaults then choose next to crave the replication instance while this happening you can specify the database endpoints which are the source and target databases on the connect source and target database influence page specify the connection information from the source or target database so it looks like the replication instance has been created successfully now I’m going to enter the details including the endpoint identifier for this demonstration of selected protein point and then the endpoint for the target is going to be a test endpoint the source and title engine for this source it will be Oracle and then for the target for this example it will be my sequel now I need to get the server name to get the server name I need to go back to the RDS dashboard so I’ll click services and open a new tab it’s opened up a new page but I need to go specifically to the RDS page I’ll select instances and as you can see here are my source and target instances to get the server name I’ll select the instance then I’ll select the details page and I’ll copy and paste the endpoint and I’ll go back to the DMS dashboard and I’ll paste the server name now to get the target silver name I go back to the IDS dashboard and I’ll select on my single target database and I’ll copy the server name or the endpoint I’ll go back to my DMS dashboard and paste the endpoint in servername website then I’ll select port for Oracle engine it’s one five two one for my single it’s three 306 and then there’s this a cell mode for this example I’ll select none and say for my target then I’ll enter my username and same for the target possible and sign for the target and for the Oracle engine the center for this example is our sale choose the advance tab to set values for connection string and encryption keys if they are acquired in this example I’m going to leave them blank you can also test an endpoint connectivity by choosing run tests so I’ve chosen our testing for both the source and target if all accessible you can proceed to the next step next we are going to create a task you specify what tables and schemers to use for migration along with specific application requirements on the crate tasks page specify task details including task name and for this example the task name is Prada endpoint – test endpoint task description in this example I’ve entered test task one source endpoint is prot endpoint and target endpoint is test endpoint the replication instance is the one we created called replication instance – and migration type you can choose to add just the existing data migrated to the target or have ongoing changes sent to a target in addition to the migrated data in this example I’m going to leave as is and choose whether to start the task on create which we will then choose the task settings tap the values here depend on the migration type you select in this example I chose migrate existing data here you specify values for your target table lob support and to enable logging I will enable logging then you have table mappings which sets values for schema mapping and the mapping method in this example I’m going to select the roots came up which I know has one table to migrate then you need to select add selection rule and that’s crated my role after you have finished choose crate task as you can see the task is now being created it may take a moment to complete as a note if you see the task is ready we can select the task and start so that’s it you have created a replication incidence source and target endpoint and have created a task that is now running you can view statistics and monitor information for your task by choosing the running tasks from the DMS console here we are looking at table statistics for the database migration and as we can see we’ve migrated the one table to stable one along with other 20,000 records and now you can see the status has changed to light complete thanks for watching and happy cloud computing from all of us here [Music]

Danny Hutson

2 thoughts on “How do I migrate databases from an RDS Oracle DB instance to an RDS MySQL DB instance using DMS?

  1. I can see much documentation on AWS migration from the on-premise Oracle DB to a different DB as a target in AWS . Why there is no such step by step process or documentation for on-premise oracle DB to AWS ORACLE RDS?

Leave a Reply

Your email address will not be published. Required fields are marked *