AWS Database Migration Service

Overview

Migrate Databases with Minimal Downtime.

AWS Database Migration Service helps you migrate databases to AWS easily and securely. The source database remains fully operational during the migration, minimising downtime to applications that rely on the database. The AWS Database Migration Service can migrate your data to and from most widely used commercial and open-source databases. The service supports homogenous migrations such as Oracle to Oracle, as well as heterogeneous migrations between different database platforms, such as Oracle to Amazon Aurora or Microsoft SQL Server to MySQL. It also allows you to stream data to Amazon Redshift from any of the supported sources including Amazon Aurora, PostgreSQL, MySQL, MariaDB, Oracle, SAP ASE and SQL Server, enabling consolidation and easy analysis of data in the petabyte-scale data warehouse. AWS Database Migration Service can also be used for continuous data replication with high-availability.

Features of AWS Database Migration Service

Simple to use - AWS Database Migration Service is simple to use. There is no need to install any drivers or applications, and it does not require changes to the source database in most cases. You can begin a database migration with just a few clicks in the AWS Management Console. Once the migration has started, DMS manages all the complexities of the migration process including automatically replicating data changes that occur in the source database during the migration process. You can also use this service for continuous data replication with the same simplicity.

Zero Downtime - AWS Database Migration Service helps you migrate your databases to AWS with virtually no downtime. All data changes to the source database that occur during the migration are continuously replicated to the target, allowing the source database to be fully operational during the migration process. After the database migration is complete, the target database will remain synchronised with the source for as long as you choose, allowing you to switchover the database at a convenient time.

Supports Most Widely Used Databases- AWS Database Migration Service can migrate your data to and from most of the widely used commercial and open source databases. It supports homogeneous migrations such as Oracle to Oracle, as well as heterogeneous migrations between different database platforms, such as Oracle to Amazon Aurora. Migrations can be from on-premises databases to Amazon RDS or Amazon EC2, databases running on EC2 to RDS, or vice versa, as well as from one RDS database to another RDS database.

Low Cost - AWS Database Migration Service is a low cost service. 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. This applies to both homogeneous and heterogeneous migrations of any supported databases. This is in stark contrast to conventional database migration methods which can be very expensive.

Fast and Easy to Set-up - You can set up a migration task within minutes in the AWS Management Console. A migration task is where you define the parameters the AWS Database Migration Service uses to execute the migration. This includes setting up connections to the source and target databases, as well as choosing the replication instance used to run the migration process. Once setup, the same task can be used for test runs before performing the actual migration.

Reliable - The AWS Database Migration Service is highly resilient and self–healing. It 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 was halted. Multi-AZ option allows you to have high-availability for database migration and continuous data replication by enabling redundant replication instances.

AWS Schema Conversion Tool

The AWS Schema Conversion Tool makes heterogeneous database migrations easy by automatically converting the source database schema and a majority of the custom code, including views, stored procedures, and functions, to a format compatible with the target database. Any code that cannot be automatically converted is clearly marked so that it can be manually converted. SCT can also scan your application source code for embedded SQL statements and convert them as part of a database schema conversion project. During this process, SCT performs cloud native code optimisation by converting legacy Oracle and SQL Server functions to their equivalent AWS service thus helping you modernise the applications at the same time of database migration. Your source database can be on-premises, or in Amazon RDS or EC2 and the target database can be in either Amazon RDS or EC2. The AWS Schema Conversion Tool supports the following conversions.

Source Database Target Database on Amazon RDS
Microsoft SQL Server Amazon Aurora, MySQL, PostgreSQL, MariaDB
MySQL and MariaDB PostgreSQL
Oracle Amazon Aurora, MySQL, PostgreSQL, MariaDB
PostgreSQL Amazon Aurora, MySQL, MariaDB
Amazon Aurora PostgreSQL
Oracle Data Warehouse Amazon Redshift
Teradata Amazon Redshift
Netezza Amazon Redshift
Greenplum Amazon Redshift

  Visit Amazon FAQ Page  


   Call WTL Professional Services Team on 0121 486 1234 to start using AWS Services   

clients testimonials

"WTL showed a thorough understanding of TRL's needs especially the wider IT infrastructure to which the new system would interface. WTL worked very hard to meet delivery deadlines and were accommodating when these changed!" - Mohamed Ismail- Research Engineer, Toshiba Research
"One of the biggest factors in choosing WTL was their experience and professionalism which gave us the confidence that the job would be completed on time and to budget." - Pete Gain, Enterprise Technology Specialist, SAS UK
"WTL performed an audit of existing support contracts and cross referenced existing infrastructure to produce an asset registry at that point in time" - United Utilities

OUR PARTNERS

The UK's Largest IT Purchasing Portal

IT Cheaper
IT Cheaper
  • Low Prices – Big Discounts
  • Quick and Easy access to 3000 of the top IT Vendors
  • Over 350,000 Individual Product SKU's
  • Over 900,000 Products In Stock for Next Business Day Delivery
Visit cibic.co.uk