Updated on 2023-05-29 GMT+08:00

Migrating the Database to HUAWEI CLOUD

You can use either of the following methods to migrate the database:

Method 1: Using SMS

To ensure data consistency between the target system and the source system, you need to stop services at the source end before the last time incremental synchronization. Then, repeat procedures in Method 1: Using SMS.

Method 2: Using the Database Backup and Restore Function

The database backup and restoration function uses the backup of the source system data and restore it in the target system.

The following uses the SAP HANA database as an example to describe how to use method to migrate the database to HUAWEI CLOUD.

  1. Migrate the source database to HUAWEI CLOUD by performing steps provided in Migrating Application Servers to HUAWEI CLOUD. Alternatively, deploy SAP HANA servers on HUAWEI CLOUD. For details, see SAP HANA User Guide.
  2. Stop the database service at the source end and perform a full backup for the database. Ensure that the necessary logs are retained. Transfer the backup file to the target server on HUAWEI CLOUD.

    You can also use OBS to transfer files. OBS provides multiple tools to accelerate the file upload. For details, see OBS Tools.

  3. Log in to the target server and use HANA Studio or run the hdbsql command to restore the backup data to the database. For details, see SAP HANA Administration Guide.

    • If the size of a full backup file is large, data transmission and restoration will take a long time. To reduce the downtime, you can restore the data on the target system using a full backup without stopping services on the source system. After you stop the services at the source end, perform a differential or incremental backup and then restore the differential or incremental backup to the target system.
    • Alternatively, you can use SMS to migrate source servers to HUAWEI CLOUD so that you do not need to deploy the system again, and part of the backup data can be migrated to the target server. You only need to perform a differential or incremental backup and then restore it to the target system.

  4. Start the SAP HANA database on the cloud and verify that the database is functional and the data is intact.
  5. Connect the application with the database to test whether the system is functional.

Method 3: Using the Database Synchronization Technology

Databases have their native tools to support synchronous data replication, such as HANA System Replication, Oracle Data Guard, On Availability Groups (SQL Server), and Q Replication of DB2.

The following uses the SAP HANA database as an example to describe how to use HANA System Replication to migrate the database to HUAWEI CLOUD.

  1. Migrate the source database to HUAWEI CLOUD by performing steps provided in Migrating Application Servers to HUAWEI CLOUD. Alternatively, you can deploy SAP HANA servers at HUAWEI CLOUD. For details, see SAP HANA User Guide.
  2. Configure asynchronous system replication from the source SAP HANA database to the target SAP HANA database. For details, see SAP HANA Administration Guide.
  3. Before the system switchover, check HANA System Replication to ensure that the data replication status is normal, and then stop the source SAP application system.
  4. Run the SAP HANA takeover command on the target database to check the database running status. For details, see SAP HANA Administration Guide.
  5. Start the target SAP application system on the cloud and ensure that the connection between the application system and HANA database is normal.
  6. Check the system availability and service data integrity on the service side.