Help Center > > User Guide> Microsoft SQL Server Database Management> Data Editing> Exporting Data in Batches

Exporting Data in Batches

Updated at: Mar 20, 2020 GMT+08:00

Scenarios

Export files in batches on the DAS console to improve the efficiency and accuracy of exporting a large amount of data.

Prerequisites

You have obtained the login permission and logged in to the database management page.

Procedure

  1. On the top menu bar, choose Import Export > Batch Export. The page for editing the export file information is displayed.
  2. Search for, create, delete, or refresh tasks as required.

    • Search for tasks.

      You can search for tasks by task status, creation time, task ID, description, and database name.

    • Delete a task.
    • Create a task.

      You can create a task using the following three types of methods: Export Database, Export SQL Result, and Quick Export Database. The following uses exporting a database as an example.

  3. Choose New Task > Export Database. On the displayed page, specify required parameters on the Basic Information and Advanced Settings tabs.

    • Basic Information

      Select the database to be exported and set the row limit, charset, and file options. The database supports SQL and CSV file types.

    • Advanced Settings.

      Export the TINYBLOB, BLOB, MEDIUMBLOB, and LONGBLOB types (in hexadecimal format).

      Export the BINARY and VARBINARY types (in hexadecimal format).

      Export the TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT types.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel