AWS Database Migration Service

February 24, 2016 at 10:26 am | Posted in Oracle Developement | 1 Comment

688_2up_rdsdatamigrationAmazon’s AWS Database Migration Service (DMS) is now in preview. This service allows you to easily migrate your on-premise database to the Amazon cloud.

This is done through a declarative interface, where you specify your source and target endpoints, and either a VPC (virtual private cloud) or VPN connection. The service will then pull your database/schema/tables and instantiate them with data (data filters are optional) on your cloud instance. The setup will only take a few minutes and DMS will handle the rest.

DMS supports for a variety of platforms and can even provide heterogeneous migrations, such as from Oracle to MySQL.

Once a migration is complete, DMS will even handle all the data changes that occurred during the migration and apply them to the target. This makes moving even production databases easier.

Among others, DMS supports Oracle Enterprise, Standard, Standard One for versions 10g, 11g, and 12g for both the source and target.

Rather than using the web interface, DMS can also be used through a command line interface.

sctIf you choose to do a heterogeneous migration, Amazon provides the AWS Schema Conversion Tool, a downloadable tool that helps to convert you database from one platform to another.

This is quite an amazing feat by Amazon. Check it out!

 

Advertisements

1 Comment »

RSS feed for comments on this post. TrackBack URI

  1. Wow. That is so elegant and logical and clearly explained. Brilliantly goes through what could be a complex process and makes it obvious.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


Entries and comments feeds.

%d bloggers like this: