9 Easy Steps for Successful Data Migration

简介: Migrate your database without service interruptions with Alibaba Cloud Data Transmission Service

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.

1.Create a migration account in the local database.

1

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

2

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

3

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

4

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

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.

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

7

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

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.

目录
相关文章
|
4月前
|
Linux 开发工具
You could try using --skip-broken to work around the problem You could try running: rpm -Va --nofi
linux配置环境变量操作失误出现:/usr/libexec/grepconf.sh: line 5: grep: command not found 的解决办法
140 2
|
5月前
|
存储 设计模式 缓存
《500 Lines or Less》(4)Contingent: A Fully Dynamic Build System(构建系统)
《500 Lines or Less》(4)Contingent: A Fully Dynamic Build System(构建系统)
|
5月前
|
编译器
“Could not determine which ”make“ command to run. Check the ”make“ step in the build configuration.”
“Could not determine which ”make“ command to run. Check the ”make“ step in the build configuration.”
|
6月前
|
Java
failed to solve with frontend dockerfile.v0: failed to create LLB definition: unexpected status code
failed to solve with frontend dockerfile.v0: failed to create LLB definition: unexpected status code
112 0
成功解决Failed to execute stage ‘Setup validation’: Cannot locate gluster packages
成功解决Failed to execute stage ‘Setup validation’: Cannot locate gluster packages
|
Unix Linux 异构计算
成功解决 ERROR: An error occurred while performing the step: “Building kernel modules“. See /var/log/nv
成功解决 ERROR: An error occurred while performing the step: “Building kernel modules“. See /var/log/nv
成功解决 ERROR: An error occurred while performing the step: “Building kernel modules“. See  /var/log/nv
|
Java Go API
译|Don’t just check errors, handle them gracefully(二)
译|Don’t just check errors, handle them gracefully(二)
97 0
|
程序员 Go API
译|Don’t just check errors, handle them gracefully(一)
译|Don’t just check errors, handle them gracefully
81 0
​Error -4075: File not found. An error occurred merging module <MODULENAME> for feature <FEATURENAME>.
​Error -4075: File not found. An error occurred merging module <MODULENAME> for feature <FEATURENAME>.
121 0
​Error -4075: File not found. An error occurred merging module <MODULENAME> for feature <FEATURENAME>.
Error: invalid option: --with-training-tools
Error: invalid option: --with-training-tools
165 0