[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]