Data migration best practices
This topic describes best practices for data migration, including migrating business or log data to MaxCompute from other platforms and from MaxCompute to other platforms.
Background information
Relational databases are not designed to process large volumes of data. If your relational database contains a large amount of data, you can migrate it to MaxCompute.
MaxCompute offers comprehensive data migration solutions and multiple distributed computing models. This lets you efficiently address challenges related to large-scale data storage and computing, which helps reduce your business costs.
DataWorks provides one-stop data integration, data development, data management, and data administration for MaxCompute. The data integration feature offers a stable, efficient, and elastic data synchronization platform.
Best practices
Migrate data between MaxCompute projects:
To migrate data between MaxCompute projects in the same region, see Use CLONE TABLE to migrate data between MaxCompute projects in the same region or Migrate data between MaxCompute projects using DataWorks.
To migrate data between MaxCompute projects in different regions, see Migrate data between MaxCompute projects in different regions using cross-project data access.
Migrate business data from other platforms to MaxCompute:
To migrate data from Hadoop to MaxCompute, see Best practices for migrating Hadoop data to MaxCompute (video). For information about common issues and solutions related to data and script migration, see Best practices for migrating self-managed Hadoop data to MaxCompute.
To migrate data from Oracle to MaxCompute, see Migrate data from Oracle to MaxCompute.
To migrate data from a Message Queue for Apache Kafka cluster to MaxCompute, see Migrate data from Message Queue for Apache Kafka to MaxCompute.
To migrate data from a Kafka cluster to MaxCompute, see Migrate data from Kafka to MaxCompute.
To migrate data from an Elasticsearch cluster to MaxCompute, see Migrate data from Elasticsearch to MaxCompute.
To migrate data from RDS to MaxCompute, see Migrate data from RDS to MaxCompute.
To migrate JSON data from OSS to MaxCompute, see Migrate JSON data from OSS to MaxCompute.
To migrate JSON data from MongoDB to MaxCompute, see Migrate JSON data from MongoDB to MaxCompute.
To migrate data from a self-managed MySQL database on an ECS instance to MaxCompute, see Migrate data from a self-managed MySQL database on an ECS instance to MaxCompute.
Migrate log data from other platforms to MaxCompute:
To migrate log data to MaxCompute using Tunnel, see Migrate log data to MaxCompute using Tunnel.
To migrate log data to MaxCompute using DataHub, see Migrate log data to MaxCompute using DataHub.
To migrate log data to MaxCompute using DataWorks, see Migrate log data to MaxCompute using DataWorks.
To migrate log data to MaxCompute using Simple Log Service, see Migrate log data to MaxCompute using Simple Log Service.
Migrate data from MaxCompute to other platforms:
To migrate data from MaxCompute to OSS, see Migrate data from MaxCompute to OSS.
To migrate data from MaxCompute to OTS, see Migrate data from MaxCompute to OTS.
After MaxCompute processes business and log data, you can use Quick BI to visualize the results. For more information, see Big data BI analysis based on MaxCompute.