Community

Blog
×
Community Blog 9 Easy Steps for Successful Data Migration

9 Easy Steps for Successful Data Migration

Alibaba Cloud provides a convenient way for migration through its Data Transmission Service (DTS). By migrating database through DTS, you can implemen.

When it comes to migration, there are many factors that need to be considered to ensure successful migration. Overlooking even the tiniest of aspects can cause failures, or worse, irreversible damages to businesses. There is no doubt that data migration is a daunting task for enterprises, regardless of size.

To address these issues, Alibaba Cloud provides a convenient way for migration through its Data Transmission Service (DTS). By migrating a local database to Alibaba Cloud ApsaraDB for RDS (RDS) using DTS, you can implement smooth database migration without any service interruption. In this article, we will illustrate how you can easily migrate your local data to the Alibaba Cloud RDS using DTS.

What is Data Transmission Service?

Data Transmission Service (DTS) is a data exchange service that streamlines data migration, data synchronization, and data subscription. DTS is capable of handling most widely used commercial and open-sourced databases, including RDBMS (Relational Database Management System) and NoSQL. DTS supports schema migration and full migration of SQL Server data.

Data Transmission Service supports schema migration of the following objects: tables, views, table triggers, synonyms, SQL stored procedures, SQL functions, custom types, plan GUIDs, rules, and defaults.

Full migration through Data Transmission Service will migrate all the data of the migration objects in a local database to the target instance. If there are any incremental updates during the migration process, the incremental data will not be migrated to the target database. Therefore, we recommend you use Data Transmission for full data migration when no data is being written to the local business database.

Restrictions on Migration

Migrating a local database to RDS is subject to the following restrictions:

  • DDL operations are not supported during migration.
  • Schema migration does not support migration of assemblies, database-level stored procedures, service brokers, full-text indexes, full-text directories, distributed schemas, distributed functions, CLR scalar functions, CLR value functions, inner tables, aggregate functions, and systems.
  • If object name mapping is enabled, other objects dependent on this object may fail to be migrated.

Overview of Migration Process

Migration type Schema migration Existing data migration
On-premises Oracle database Schema Owner Schema Owner
Target RDS MySQL instance Read and write permissions of the database to be migrated Read and write permissions of the database to be migrated

Note: Before the migration, create a migration account in the local database and RDS instance, create the database to be migrated in the RDS instance, and grant the read/write permissions of the database to the migration account. Different migration types need different permissions.

Step 1: Create a migration account in the local database.

1

Step 2: Grant permissions to the migration account in the local database. The required permissions are described in the table above.

2

Step 3: In the RDS console, click [Migrate Database] to enter the Data Transmission interface, as shown in the figure below.

3

Step 4: Click [Create Online Migration Task] to enter the Create Migration Task page, as shown in the figure below.

4

Step 5: Enter the task name, local database information and target database information. Click [Authorize White List and Next], as shown in the figure below.

5

Step 6: Select the migration type, select the migration object from [Migration Objects], and click > to put the migration object in Selected. Then click [Pre-check and Start], as shown in the figure below.

6

To modify the migration object name in the target database, click Edit on the right side of the Selected list.

Step 7: The system displays the result of the pre-check, as shown in the figure below.

7

Step 8: Click on the ! icon to check the failure details with the failed, and troubleshoot accordingly. If there are no failures, click Next.

Step 9: After pre-check is successful, start the migration task. The migration status and progress can be viewed in the task list.

Note: To ensure security of the local database, delete the migration account in the local database and RDS instance after the data migration is complete.

That's it! You can now enjoy the benefits of automated monitoring, backup and disaster recovery capabilities with Alibaba Cloud ApsaraDB for RDS.

Visit the Alibaba Cloud Data Transmission Service page to discover how you can easily migrate your database to Alibaba Cloud. Or talk to our experts today to learn about the Alibaba Cloud Migration Service.

New to Alibaba Cloud? Sign up for an account and get up to $1200 New User Free Credit to try over 40 products and services. Or visit Getting Started with Alibaba Cloud to learn more.

0 0 0
Share on

Alibaba Clouder

701 posts | 105 followers

You may also like

Comments