Skip to content

migrating data to MatrixOne Overview

MatrixOne tools and functions for migrating data

When using MatrixOne, it is sometimes necessary to migrate data from other databases to MatrixOne. Due to differences between different databases, data migration requires some extra work. To facilitate users to import external data quickly, MatrixOne provides a variety of tools and functions.

Here are some of the standard tools and functions:

LOAD DATA

Like MySQL, MatrixOne provides the LOAD DATA function, allowing users to quickly and parallelly import external CSV files or JSON files into tables that match the table structure.

SOURCE

In MatrixOne, you can also use the SOURCE command to migrate data and table structures to the target database.

For more information on bulk import using LOAD DATA or SOURCE, see Bulk Load Overview.

Reference

MatrixOne provides the following documents to help you quickly understand how to migrate data from other databases to MatrixOne: