Updated on 2024-01-02 GMT+08:00

Overview

It often becomes necessary to hide a real IP address of your database for the sake of security. Migrating data through direct connections is an option, but costly. DRS supports backup migration, which allows you to export data from your source database for backup and upload the backup files to OBS. Then, you can restore the backup files to the destination database to complete the migration. Using this method, data migration can be realized without exposing your source databases.

DRS supports full migration and full+incremental migration.

Scenario 1: Full Backup Migration

In this scenario, you need to stop services, upload the exported full backup file of the Microsoft SQL Server database to OBS, and then restore the backup data to the destination database.

Figure 1 Full migration

Scenario 2: Full+Incremental Backup Migration

In this scenario, data is migrated continuously. After a full backup and restoration is complete, you can perform incremental migrations for several times to minimize service interruption. A complete restoration process involves restoring several incremental backup files. The destination DB instance will not be available until the last backup file is restored. You can determine whether the selected backup file is the last one.

Figure 2 Full+incremental migration