This blog introduces the AWS database migration service, a cloud-based tool, used extensively for migrating databases to the cloud.
DMS can be used to migrate the legacy database to the cloud. However, its usage is not only limited to migration, but also provides other features like replicating databases across the regions and archiving data to S3
There are a couple of migration scenarios that are generally used:
When migrating the database as per the scenario, DMS is not alone which is being used. As the DMS tool is widely used to support both homogeneous and heterogeneous migrations, other migration tools can be used as a combination to fulfill the migration requirements.
The following tools can be used as per the requirements:
Type of migration and tools
If homogeneous (source and destination databases are the same) migration is planned, only DMS service can be used to migrate the database. However, still DMS does move the basic schema which is essential to move the data.
It is a must to first convert the schema in case of heterogeneous migration. The SCT tool will first create the target database and then process and analyze the source database schema. Then it will start the conversion with some actions requiring manual intervention as well.
The benefit of SCT tool is to make the migration easy by analysis and recommendations, it also making the migration compatible with other databases i.e. MySQL, SQL Server, Oracle, PostgreSQL.
When the schema is ready after resolving the conflicts, DMS can be used to migrate the data into a target database.
DMS also supports the DW migration, we can use the SCT extender to store the data in S3 storage. SCT tools can convert the data source i.e., Oracle, SQL Server, Teradata, Vertica, Snowflake, and many more. The following image explains the SCT data extractor functionality.
As we have seen that DMS can be used to migrate any database supported by AWS, it is a secure and safe tool widely used by database experts. There are the benefits of migrating a database through DMS:
While migrating a database, DMS creates a few objects to support the migration:
Replication tasks start the data migration through the rules defined and use the CDC to sync the target database, application can be switched to a new instance once data is in sync state.
NOTE: Important points:
Complete the following steps to migrate MSSQL Database created on the RDS
Step-1 Two MSSQL instances have been created on RDS as below:
Once we have the source and destination available, create a DMS agent.
Note: Target endpoint can be created by same by changing the end point type target.
Selection rules can be defined as below, at least one rule is required
DB Migration task is now ready to execute, just click on Action->Restart/Resume to start it manually.
DMS is a crucial service when planning to migrate databases to the AWS cloud. Good thing is that DMS supports almost every database as a source and target, so it is easy to move our business to the cloud. We must learn more about the other tools which can be used in combination with DMS service.
Use the Feedback tab to make any comments or ask questions. You can also start a conversation with us.