Help Center/ Relational Database Service/ User Guide (Ankara Region)/ Working with RDS for PostgreSQL/ Database Migration/ Migrating Data to RDS for PostgreSQL Using the Export and Import Functions of DAS
Updated on 2024-04-11 GMT+08:00

Migrating Data to RDS for PostgreSQL Using the Export and Import Functions of DAS

Scenarios

To back up or migrate data, you can use Data Admin Service (DAS) to export data from the source database first and then import the data to from your local PC or OBS bucket to the destination database.

Constraints

  • Only one file that is no larger than 1 GB can be imported at a time.
  • Binary fields such as BINARY, VARBINARY, TINYBLOB, BLOB, MEDIUMBLOB, and LONGBLOB are not supported.

Exporting Data

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and a project.
  3. Click Service List. Under Databases, click Relational Database Service.
  4. On the Instances page, locate the DB instance and click Log In in the Operation column.
  5. On the displayed login page, enter the username and password and click Log In.
  6. On the top menu bar, choose Import and Export > Export.
  7. On the displayed page, click Create Task and choose Export Database or Export SQL Result as required. The following takes database export as an example.

    Alternatively, click Quick Export and select the target database. On the displayed page, select a storage path and click OK.

  8. On the displayed page, set parameters as required in areas Basic Information and Advanced Settings. Then, select the tables to be exported on the right.

    • In a SQL result export task, the executed SQL statements cannot exceed 5 MB.
    • Databases are classified into user databases and system databases. System databases cannot be exported. If system database data is required, deploy system database services in a created user database, so that you can export the system database data from the user database.
    • DAS connects to your standby database to export data. This prevents the primary database from being affected by data export. However, if the standby database has a high replication delay, the exported data may not be the latest.

  9. After settings are complete, click OK.
  10. In the task list, view the task ID, type, status, and progress.
  11. Click Details in the Operation column to view task details.

Importing Data

  1. On the top menu bar, choose Import and Export > Import.
  2. Import a file from your local PC or an OBS bucket.

    • From your local PC

    In the upper left corner, click Create Task. On the displayed page, select an import type, select Upload file for File Source, set the attachment storage, and upload the file. Then, set other parameters as required.

    For security purposes, imported files are stored in OBS buckets.

    • To keep your data secure, provide your own OBS bucket to store the attachments you upload. In this way, DAS automatically connects to your OBS bucket for in-memory reading.
    • If you select Delete the uploaded file upon an import success, the file you uploaded will be automatically deleted from the OBS bucket after being imported to the destination database.
    • From an OBS bucket

      In the upper left corner, click Create Task. On the displayed page, select an import type, select Choose from OBS for File Source, and select a file from the bucket. Then, set other parameters as required.

    The file uploaded from an OBS bucket will not be deleted upon an import success.

  3. After setting the import parameters, click Create. Confirm the information again before you click OK because original data may be overwritten after data import.
  4. View the import progress in the task list or check task details.