Database export

Export limits

If the current control mode of the instance does not meet your business requirements, an administrator or DBA can change the control mode. For more information, see Change the control mode of an instance.

In the instance tree on the left, right-click the target instance, choose Control mode, and then select the desired mode, such as Flexible Management, from the submenu.

Precautions

• If you export data to an Excel file, the export may fail if a cell contains more than 32,767 characters.

• The exported files of a database export ticket are retained for up to 180 days. After 180 days, the files can no longer be downloaded.

Procedure

1. Log in to DMS 5.0.

2. Move the pointer over the icon in the upper-left corner of the DMS console and choose All Features > Database Development > Data Export > Database Export.

   Note

   If you use the DMS console in normal mode, choose Database Development > Data Export > Database Export in the top navigation bar.

3. Configure the parameters for the data export ticket.

   Parameter	Description
   Database Name	Select the database to export.
   Exported Table	Select Partial Tables or All Tables. If you select Partial Tables, select the required tables in the pane on the right. Note To configure filter conditions for specific tables, double-click the WHERE clause.
   Stakeholder	Add stakeholders who can view and collaborate on the ticket. The ticket is not visible to other users, except for administrators and DBAs.
   Export Content	Select the content to include in the export: Data: Exports table data as INSERT statements. Structure: Exports the table schema as CREATE statements. Data and Structure: Exports both the table data and schema.
   File Format	Specifies the format of the exported file. SQL CSV EXCEL
   Exported Structure Type	Select the types of schema objects to export. Procedure Function Trigger View Event Note The supported schema objects vary by database type. See the console for available options.
   Export Timeout	The timeout period for the export task, in seconds. The value can range from 0 to 2,147,483. If you leave this blank, DMS uses the default instance-level export timeout. To view the instance-level timeout, see Add a database instance. Note The task fails if it does not complete within the specified timeout period.
   More Options	Click Big Data Export Options or SQL Script Options and select the desired options. Big Data Export Options Export TINYBLOB, BLOB, MEDIUMBLOB, and LONGBLOB types (hexadecimal format). Export BINARY and VARBINARY types (hexadecimal format). Export TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT types. SQL Script Options Generate a DROP TABLE statement before the CREATE TABLE statement. Generate a TRUNCATE TABLE statement before the INSERT statement. Compress INSERT statements and merge VALUES into blocks of 5 MB.
   Attachments	You can upload images or documents to provide more context for the ticket.

4. After you complete the configuration, click Submit and wait for approval.

   You can track the approval progress in the Approval section on the ticket details page.

   Note

   • Exports from instances in Flexible Management or Stable Change mode do not require approval.

   • The approval process for tickets is configured by administrators or DBAs. To customize the approval process, see Customize approval workflows for tickets.

5. After the ticket is approved, in the Download section, click Download Exported File.

Next steps

• After the export is complete, consider unsubscribing from the Stable Change or Secure Collaboration modes to avoid unnecessary costs. To do so:

  1. Change the control mode of the instance to Flexible Management. For more information, see Change the control mode of an instance.

  2. In DMS Order Management, unsubscribe from the target control mode product. For more information about the refund policy, see Refund policy.

• If the export is no longer needed, close the ticket promptly to prevent potential data leaks. For more information, see Close a ticket.

API reference

• Create a ticket to export a database

• Get the details of a database export ticket

• Get the download URL of an exported database file

FAQ

• Q: If I change the control mode before exporting, can I switch the instance back to the original mode after the export?

  A: Yes. For more information, see Change the control mode of an instance.

• Q: Does database export support scheduled execution?

  A: No. Database export supports immediate execution only. To export data on a schedule, use SQL Result Set Export and select scheduled execution in the execution policy.

• Q: Does changing the maximum number of rows returned by a single query trigger data export approval?

  A: No. The maximum number of rows returned by a single query only controls how many results are displayed in the SQL console. It is independent of data export approval, so changing this setting does not trigger export approval. If you need to export more rows than this limit allows, submit a data export ticket.

• Q: What do I do if a database export fails?

  A: Troubleshoot the issue in the following order:

  1. Make sure that you are logged on to the database that you want to export in DMS. If you are not logged on when you submit the ticket, DMS reports that Database Name is a required field. For more information, see the Prerequisites section of this topic.

  2. Check whether your account has the permissions required to export the database. If you do not have the required permissions, the database is not displayed in the Database Name drop-down list. For information about how to view and apply for permissions, see the Prerequisites section of this topic.

  3. Check whether the Export Timeout value is too low. If the value is too low, the export task fails with an i/o timeout error before the export is complete. For more information about this parameter, see the description of Export Timeout in the Procedure section of this topic.

  4. Check whether the row limit of the control mode of the instance meets your export requirements. For the row limit and file size limit of each control mode, see the Export limits section of this topic.