AWS Database Migration Service

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

Amazon’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.

If 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!