Data Management (DMS) provides the database export feature. You can use this feature to back up databases and export databases or tables for data analysis. You can submit a ticket to export databases.
Prerequisites
The database is of one of the following types:
MySQL: self-managed MySQL, ApsaraDB RDS for MySQL, PolarDB for MySQL, AnalyticDB for MySQL, and ApsaraDB for OceanBase in MySQL mode
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
Oracle: PolarDB for PostgreSQL (Compatible with Oracle)
ApsaraDB for MariaDB and MariaDB databases from other sources
Usage notes
DMS allows you to export up to one million data rows for free per day for instances managed in Flexible Management mode, up to 20 million data rows for free per day for instances managed in Stable Change mode, and an unlimited number of data rows for instances managed in Security Collaboration mode. If you need to export a large number of data rows every day, you can change the control mode of the instances to Security Collaboration. For more information, see Change the control mode of an instance.
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. To close a ticket, go to the Ticket Details page of the ticket and click Close Ticket in the upper-right corner of the page.
Procedure
- Log on to the DMS console V5.0.
In the top navigation bar, choose .
NoteIf you use the DMS console in simple mode, move the pointer over the icon in the upper-left corner and choose
.You can also choose SQL Console > SQL Console in the top navigation bar. In the left-side pane of the page that appears, right-click the table that you want to export and select Export.
On the Data Export Tickets page, configure the parameters that are described in the following table.
Parameter
Description
Database Name
The database that you want to export.
NoteYou 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.
NoteIf you set this parameter to Partial Tables, you must select one or more tables in the Tables & Filters section and configure the filter condition.
Reason Category
The reason for this export. This helps you find the ticket in subsequent operations.
Business Background
The purpose or objective of this export. This reduces unnecessary communication.
Stakeholder
The stakeholders involved in this export. All specified stakeholders can view the ticket details and take part in the approval process. Irrelevant users other than DMS administrators and database administrators (DBAs) are not allowed to view the ticket details.
Export content
The type of data that you want to export. Valid values: Data, Structure, and Data & Structure.
File Format
The format in which the database is exported. Valid values:
SQL
CSV
EXCEL
Exported Structure Type
The type of schema that you want to export. Valid values:
Procedure
Function
Trigger
View
Event
NoteThe valid values vary based on the type of database that you want to export.
More Options
Other objects you want to export. Click Big data type export options or SQL script other options and select the required options.
Attachments
The images or files that are uploaded to add more information about this export.
Click Submit.
NoteOn the Ticket Details page, you can view the approval progress in the Approval section.
Approval rules are configured by DMS administrators and DBAs. For more information about how to customize an approval process, see Customize approval processes.
After the ticket is approved, click Download Exported File in the Download step.
ImportantYou must download the exported file within 24 hours after the ticket is executed. Otherwise, the export link becomes invalid and you need to submit a ticket again.
Other supported operations
After you export data, you can perform the following operations:
You can import the exported data to another database. For more information, see Import data.
If you need to delete a database after you export the data in the database, perform the following operations: In the left-side navigation pane on the Home tab, right-click the database instance that you want to manage and select Database management. On the page that appears, find the database that you want to delete, click Delete in the Actions column, and then click OK. For more information about how to delete a database, see Manage databases.
You can also call the following API operations to create and execute a database export ticket: