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. A data migration project consists of the following steps:
Data migration
OMS automatically runs the data migration project without any human intervention in the interim. You do not need to start, suspend, or interrupt the process.
Data verification
After the data migration is completed, you can verify the data integrity and accuracy.
Synchronization link switching
Before your business is applied to the destination database, you can switch the synchronization link to create a synchronization link from the destination database to the source database.
Switch your business to the source database.
Create a rollback plan before you switch your business, to reduce the impact of data migration on your business.
Optional. 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.