This session describes how to export SQL result sets in DMS.
You have access permissions to DMS and you have logged on to the DMS console. Select a target database and log on.
This example uses the MySQL database.
Log on to the DMS console. The homepage is displayed, as shown below:
Select a MySQL database and click Log On to Database. The logon window is displayed, as shown below: Enter required information and click Log On.
On the top menu bar, choose Data Processing > Export to go to the Export page.
On the Export page, choose New > Export SQL result sets, as shown below:
On theNew page, complete the settings as needed. Select a file type (CSV or SQL_Insert) and a database, set the maximum number of rows of the result set, and enter an SQL statement, as shown below:
Select advanced options as needed.
Click OK. DMS then runs the SQL result set export task. After the export task is completed, DMS automatically downloads the exported files to your local computer. You can click Download Files to download the exported files, as shown below:
This operation is similar to Export Database.
DMS also summarizes the export results and automatically downloads the exported SQL result set files.
You can view the SQL result set export tasks that you submitted in the Export History List and download SQL result set files.