:Export tasks

Task list

On the management page of the target database connection, click Task Center in the top navigation bar to open the Task Center panel. Click Export to display the task list.

The following table describes the columns in the task list. You can filter and sort tasks by some of the columns.

Create an export task

1. Log on to ODC and go to the management page of the target connection. In the top navigation bar, click Task Center. On the Task Center panel that appears, click + on the right side of Export, and a new export task panel will pop up.

   

2. Specify the export content

   

   ODC supports three export modes: Export Schema and Data, Export Data Only, and Export Schema Only. Export Schema Only exports the definition statements of the target object. You can select the export content from the Export Content drop-down list. For more information about formats, see Export and import formats.

3. Select a database

   Select the database where the object to export resides. The name of the database connection to which the task belongs is also displayed.

4. Specify the export range

   You can select Partial Export or Full Export.

   • If you select Partial Export, you can select the objects you want to export in the Select Objects pane in the Export Objects section. You can use the search box to search for desired objects.

   • If you select Full Export, all objects in the database are exported.

5. Go to the Export Settings panel

   Click Next: Export Settings to specify the file export settings and the sys tenant account.

6. Go to the Data File Settings panel

   
   Note

   If you select Export Schema Only for Export Content, you do not need to configure the export data settings.

   1. Specify Data Format.

      ODC supports exporting data to files in the CSV format and SQL format. If you specify Export Schema Only for Export Content, you can only export data to files in the SQL format.

   2. Specify File Encoding.

      ODC supports the following encoding standards: ASCII, ISO-8859-1, GB2312, GBK, GB18030, Unicode (UTF-8), Unicode (UTF-16), Unicode (UTF-32), and BIG5. You can select the encoding standard from the File Encoding drop-down list.

   3. Specify Data Desensitization.

      By default, desensitization is disabled. You can select and manage the names of the desensitization strategies. In the Manage Desensitization Strategies section, you can add, edit, or delete strategies. For more information, see .

   4. Specify Maximum Size of a Single File.

      If you select Export Schema Only for Export Content, you do not need to set the maximum size of a single file.

      You can choose the upper limit of the exported single file. If the data file of a single table exceeds the upper limit, the file will be automatically split up. If you specify not to limit the file size, the file will not be split up.

   5. Specify Data File Settings.

      • Use Global Snapshot: If you select this option, ODC exports the data in the latest global snapshot of the specified table to ensure global data consistency.

      • Batch Commit Quantity (SQL Format): You can click Advanced next to Export Data Settings to specify this field. If you select SQL Format for Data Format, you can specify the number of rows to be committed during the export. When this number is reached, a COMMIT command is executed.

      • Specify information for the CSV format.

7. Specify schema file settings

   • If you select Export Schema Only for Export Content, you can choose whether to select Merge Exported Results into an SQL File. If you select this option, the DDL will be merged and exported as a SQL file.

   • Choose whether to select Add DROP TABLE Statement before CREATE TABLE Statement. If you select this option, a DROP statement is added before the corresponding CREATE statement of an object when the schema files of the object are exported.

8. Select an execution method

   Select Execute immediately or Timed execution.

9. Retain Current Configuration

   Check Retain Current Configuration to keep the current part of the data file and structure file configuration.

10. Generate an export task

    After you specify all preceding information, you can click Export in the lower-right corner of the panel to create an export task and export the backup file directly to a local directory.

View an export task