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

Exporting Data

Updated at: May 14, 2020 GMT+08:00

Scenarios

DAS supports pagination query to meet your requirements for querying large amounts of data. You can export all the data at a time when backing up or migrating data.

The following lists the methods used for exporting data in different scenarios.

Prerequisites

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

Method 1

Export data from the menu bar on the top.

  1. On the top menu bar, choose Import Export > Export.
  2. On the displayed page, select the database name, data position, file format, and table names as required, and click Export.

    • If you want to export data from a single table, select the table name and click or Export.
    • If you want to export multiple tables at a time, select tables to be exported in batches and click Export.

      A maximum of 10000 rows can be exported at a time.

Method 2

For details about how to export the database data, see section Exporting Data.

Method 3

For details on how to export the table data, see section Exporting Table Data.

Method 4

Execute SQL statements to export result sets.

  1. On the top menu bar, choose SQL Operation > SQL Window.
  2. Enter the SQL statements in the SQL window and click Execute SQL.
  3. View the execution results and export the file as required.

    A maximum of 10000 rows can be exported at a time.

Method 5

Export the table data.

  1. In the navigation tree on the left, locate the target table and choose Open Table. On the displayed tab, select the output format (CSV or SQL) and click Export. Then, the export file will be downloaded to your local PC.

    A maximum of 10000 rows can be exported at a time.

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