Data Management (DMS) provides the database export feature. You can use this feature to export an entire database or specific tables in the database for data analysis.

Prerequisites

One of the following types of databases is used:
  • MySQL: self-managed MySQL, ApsaraDB RDS for MySQL, PolarDB for MySQL, PolarDB-X, AnalyticDB for MySQL, and ApsaraDB OceanBase for MySQL
  • SQL Server: self-managed SQL Server and ApsaraDB RDS for SQL Server
  • PostgreSQL: self-managed PostgreSQL, ApsaraDB RDS for PostgreSQL, PolarDB for PostgreSQL, and AnalyticDB for PostgreSQL
  • PolarDB for Oracle
  • MariaDB
Note For more information, see Supported database types and features.

Procedure

  1. Go to the DMS console V5.0.
  2. In the top navigation bar, click Database Development. Then, choose Data Export > Database Export in the left-side navigation pane.
    Note To create a data export ticket, you can go to the SQLConsole tab, right-click a table name, select Export, and then select the object to be exported.
  3. On the Data Export Ticket Application page, set the parameters that are described in the following table.
    Set the parameters for database export
    Parameter Description
    Database Name The database that you want to export.
    Note You must have the export permissions on this database. For more information, see View owned permissions.
    Exported table Specifies whether to export specific tables or all tables in the database. Valid values: Partial Tables and All Tables.

    If you set this parameter to Partial Tables, you must select one or more tables in the Tables & Filters section and configure the filter condition for each table.

    Export content The type of data that you want to export. Valid values: Data, Structure, and Data & Structure.
    Exported Structure Type The type of schema that you want to export. Valid values:
    • Procedure
    • Function
    • Trigger
    • View
    • Event
    More Options The other objects that you want to export. Click Big data type export options or SQL script other options and select the required options.
  4. After you complete the configurations, click Submit and wait for approval.
    Note On the Data Export Ticket Details page, you can view the approval progress in the Approval step.
  5. After the ticket is approved, click Download Exported File in the Download step.
    Download Exported File

Usage notes

  • After you submit a data export ticket for approval, you can close the ticket regardless of whether the ticket is approved or rejected. This reduces data exposure.
  • Approval rules are configured by DMS administrators and database administrators (DBAs). If you are a DMS administrator or DBA, click Security and Specifications in the top navigation bar of the DMS console. Then, click Security Rules in the left-side navigation pane to configure approval rules for data export tickets. We recommend that you submit tickets to export data in the test environment. This way, affected rows can be checked and a backup file can be created for each data export. This also allows you to restore data when the data export does not work as expected. To ensure high R&D efficiency, you can specify that no approval is required for data export tickets in the test environment.