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.
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.
Migrating a local database to RDS is subject to the following restrictions:
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.
Alibaba Cloud Data Transmission service supports data transmission between database-centered structured storage products.
Alibaba Cloud Data Transmission Service supports data transmission between database-centered structured storage products. It integrates a wide variety of data transmission capabilities, including data migration, data subscription, and real-time data synchronization. With Data Transmission Service, you can easily build a secure, scalable, and highly available data architecture while achieving a one-click cloud migration. Data Transmission Service supports data migration between common database types including Oracle, MySQL, SQL Server, and Postgres Plus Advanced Server. Meanwhile, it also supports incremental data subscription for ApsaraDB for RDS MySQL and real-time synchronization between ApsaraDB for RDS instances.
Before ApsaraDB for RDS initiates data migration, Data Transmission Service will run a series of pre-check tests to ensure successful migration. This article briefly introduces the content found during the pre-check phase, as well as the causes of failures and solutions for each pre-check item.
Source Database Connectivity Check
This check aims to test whether the Data Transmission server can connect to the source database to be migrated. Data Transmission creates a connection to the source database through the JDBC protocol. When the creation fails, this check item fails.
The source database connection pre-check may fail for the following reasons:
1.Incorrect account or password provided when the migration task is created
Check method: Connect to the source database through client software on any network-ready server that can connect to the source database with the account/password used for creating the migration task, and confirm whether the connection works normally. If the connection reports errors, and the error prompt contains Access deny, it indicates the account or password is incorrect.
Solution: Modify the migration task in the Data Transmission Service console and enter the correct account and password, and then re-run the pre-check.
2.Source database migration account places restrictions on the source IP address
select host from mysql.user where user='migration account',password='migration account password'.
grant all on . to "migration account"@"%" identified by "migration password"in the source database to re-authorize the migration account. Replace the migration account in this command with the real migration account and migration password with the real migration password. Re-run the pre-check after authorization.
Alibaba Cloud Data Transmission Service (DTS) lets you perform data migration without stopping services, ensuring data reliability while maintaining business continuity.
More and more enterprise customers are choosing to migrate to the cloud to fully benefit from its convenience and high reliability. However, for many customers, the first issue encountered when migrating to the cloud is to smoothly complete the cloud migration without affecting the business. Many traditional migration solutions require businesses to stop services during migration, which affects business continuity.
Alibaba Cloud Data Transmission Service (DTS) has the ability to perform data migration without stopping services, meaning the cloud migration is completed while the source database provides the normal services of the business. In this article, we will discuss the principles and process of cloud migration, as well as explain the benefits of using Alibaba Cloud's DTS.
A variety of database engines have emerged in the market to meet different user scenarios. To meet user requirements for importing data, database vendors typically have their own data migration tools. For example: mysqldump for MySQL and exp/imp for Oracle.
However, traditional migration tools realize the migration of existing data through data export and import. To ensure the integrity of the migrated data, the source database service is usually stopped and the amount of time for which the service remains stopped depends on how long it takes to migrate the existing data. This can be several hours, and results in an extremely high migration cost for users.
Alibaba Cloud provides a migration service called Data Transmission Service (DTS), to reduce the migration cost to users. DTS supports data transmission between data sources such as relational databases, NoSQL, and Big Data (OLAP). It is a data transmission service that integrates data migration, data log real-time subscription, and real-time data synchronization.
DTS provides data migration without stopping services, enabling the smooth completion of the migration of database data without stopping the services related to the source database. Users can apply data migration in various scenarios:
This document shows you how to migrate your local data to Alibaba Cloud. It provides actionable solutions to multiple migration scenarios.
With the rapid development of cloud computing services, migrating existing server systems to the cloud easily and quickly is of great significance for most enterprises. In response, Alibaba Cloud has launched the server migration services. This migration service is a one-click solution that provides easy-to-use server system migration tools, helping to reducing costs while streamlining the server migration process.
Using the migration services makes light work of system migration. For more information on conditions of use and basic usage, you can refer to the migration tool help documentation.
Migrate your systems. For inquiries, contact Alibaba Cloud's Support Team.
Experts estimate that 80 to 90 percent of the data in any organization is unstructured. Many organizations believe that their unstructured data stores include information that could help them make better business decisions. but to analyze unstructured data, there are some main challenges in terms of data migration. This course introduces the basic concepts of unstructured data, Alibaba Cloud unstructured data migration tools and service, Alibaba Cloud unstructured data SDK and how to use OssImport tool for unstructured data migration.
Most applications use structured database software for data storage, such as: My SQL, SQL Server, Oracle. This course introduces the basic concepts of structured data storage, storage modes, and data migrations, focusing on how to use the Alibaba Cloud data migration service and DTS(Data Transmission Service) for structured data migration to the cloud.
This course is designed to help traditional IT companies who want to move their business to the cloud and have a comprehensive understanding of Alibaba Cloud's recommendations and available tools for the migration of the application environment. So that you can choose the most appropriate way to complete the migration.
A workload mover software solution, supports Physical-to-Cloud, Virtual-to-Cloud, and Cloud-to-Cloud. The very first on-line migration solution tightly integrated with Alibaba Cloud.
Quickly learn the basic concepts and architectures of MaxCompute and DataWorks, and how to perform data integration with multiple data sources and formats.
This topic describes how to migrate data of an Internet enterprise from a cloud service to Alibaba Cloud Object Storage Service (OSS).
Enterprise A is an Internet service provider that deploys the main business applications in a cloud service provided by Cloud Service Provider B. The main business applications of Enterprise A provide online editing services for media files, such as images and videos. The existing data that is stored on the servers of Cloud Service Provider B includes 100,000,000 files and has a total size of about 320 TB with a daily increase of 20 GB. The bandwidth for both the storage service of Cloud Service Provider B and OSS is 250 MB/s. The business applications require a maximum bandwidth of 50 MB/s.
Enterprise A wants to switch over the businesses to OSS based on the development needs. When you switch over businesses between two data stores, you must migrate existing data and incremental data to OSS. To ensure a successful migration of large amounts of historical data and business continuity, the following needs must be met:
Based on the background information, you can migrate data as follows:
You can use DTS to migrate data between various types of data sources. Typical scenarios include data migration to Alibaba Cloud, data migration between instances within Alibaba Cloud, and database splitting and scale-out. DTS supports data migration between homogeneous and heterogeneous data sources. It also supports extract, transform, and load (ETL) features such as object name mapping and data filtering.
For more information about data migration in various scenarios, see Overview.
Supports data migration and data synchronization between data engines, such as relational database, NoSQL and OLAP
Heterogeneous database migration has always been a pain point of database migration. Traditionally, assessment of the compatibility and workload is difficult to complete in a short time; and it is also difficult to automatically output the transformation scheme and sort out the relationship between the database and the application. ADAM decreases the difficulty of heterogeneous database migration with functions of compatibility assessment, structure transformation suggestion, migration workload evaluation, application transformation assessment and suggestion.
Alibaba Cloud Product Launch - January 22, 2019
Alibaba Clouder - March 30, 2018
Rupal_Click2Cloud - July 27, 2021
Alibaba Clouder - March 1, 2021
Alibaba Clouder - October 29, 2020
Alibaba Clouder - November 6, 2017
More Posts by Alibaba Clouder