OceanBase Migration Service (OMS) provides the data migration feature to help you migrate data from other data sources to OceanBase Database online in real time. OMS also provides the following features: data verification, synchronization link switching, and migration project clearing.
The OMS server needs to be connected to both the source instance and the destination instance. To start a data migration project, configure the source and destination databases and select the tables to be migrated.
To create and manage a data migration project, perform the following steps:
Prepare for data migration.
Before you migrate data by using OMS, create a user in the source or destination database and authorize the user. For more information, see Create and authorize a database user.
Add a data source.
In the OMS console, add the source and destination databases as data sources. For more information, see Create a data source.
Create a data migration project.
Specify the source database, destination database, migration type, and tables to be migrated in the migration project. For more information, see data migration pipeline documents.
After your data migration project passes the pre-check, start your project.
View the status of the data migration project.
On the migration project monitoring page, you can view the link details and monitor the migration project status in real time. For more information, see View details of a data migration project.
Optional. Stop and release the data migration project.
After the data migration project is completed and data no longer needs to be synchronized from the source database to the destination database, you can clear the current data migration project. For more information, see Delete a data migration project.