DMS supports three types of data export. Use the table below to choose the right method for your use case.
| Method | What it exports | Supported formats | Approval required |
|---|---|---|---|
| Export table schemas | DDL definitions for one or more tables | Word, Excel, PDF | No |
| Export SQL query result sets | Rows returned by a SQL query (relational databases only) | CSV, Excel, and others | Yes |
| Export entire database | Tables, data, and database objects such as stored procedures, functions, triggers, views, and events | — | Yes |
Prerequisites
Before you begin, make sure that:
The Result Set Export Support rule is enabled for the security rule associated with your database. This rule is enabled by default. For details, see SQL Console - Relational Database.
You have query and export permissions for the target database. For details, see Manage Resource Access Management Permissions.
Export table schemas
Export the data dictionary document for one or more tables in Word, Excel, or PDF format. This method does not require ticket approval.
Log on to the DMS console V5.0.
In the Database Instances list on the left, find the target database.
Double-click the database name to open the SQL Console.
Right-click the target table and choose Export > Export Table Schema.
Alternatively, click the extension icon in the upper-right corner and select Entire Database Table Schema.
On the Export Table Schema page, select a format and download the data dictionary document. Supported formats: Word, Excel, and PDF.
Export SQL query result sets
Export rows returned by a SQL query as a file. This method supports relational databases only and requires ticket approval.
Exporting result sets from NoSQL databases is not supported.
The SQL Console displays up to 3,000 rows. To export more than 3,000 rows, use this method instead of copying results from the console.
Log on to the DMS console V5.0.
In the Database Instances list on the left, find the target database.
Double-click the database name to open the SQL Console.
In the Execution Result area, choose Export File > Export More Data.
Configure the export parameters and click Confirm.
Parameter Description Reason Category Select the reason for the export to facilitate future searches. Business Background Describe the purpose or goal in detail to reduce communication costs. Relevant Personnel Add collaborators who need to view or act on the ticket. Other users (except administrators and DBAs) cannot access the ticket. Export SQL Statement Enter the SQL statement to export. Embed Watermark Select a watermark type to embed identification information in the exported file. For details, see Embed Watermark. Options: Data watermark embeds identification information in the data in a way not directly visible to users — requires sensitive data protection to be enabled and the export must contain more than 200 entries. File watermark embeds identification information that is directly visible in the exported file. In the Ticket Generated Successfully dialog box, click View Ticket.
On the ticket details page, verify the Affected Rows count in the Precheck area, then click Submit for Approval.
After the ticket is approved, the system runs the export task automatically. When the task completes, click Execute Export on the ticket details page. Select the file type, Data, Character Set, and any other options, then click Confirm Execution.
Click Download Exported File to save the file to your local computer.
When exporting in CSV format, Excel may display date fields as serial numbers or garbled characters because CSV files contain no formatting information. To fix this, select the date column in Excel, right-click, and choose Format Cells > Date.
Export entire database
Export an entire database, including tables, data, and database objects such as stored procedures, functions, triggers, views, and events.
Log on to the DMS console V5.0.
In the Database Instances list on the left, find the target database.
Double-click the database name to open the SQL Console.
Right-click the target table and choose Export > Export This Database.
Alternatively, click the extension icon in the upper-right corner and select Export This Database.
Configure the export parameters.
Parameter Description Exported Tables Select All Tables or Partial Tables. If you select Partial Tables, choose the specific tables on the right. Reason Category Select the reason for the export to facilitate future searches. Business Background Describe the purpose or goal in detail to reduce communication costs. Relevant Personnel Add collaborators who need to view or act on the ticket. Other users (except administrators and DBAs) cannot access the ticket. Export Content Select what to export: Data, Structure, or Data and Structure. Export Structure Type Select the database object types to include: Stored Procedure, Function, Trigger, View, or Event. Available options vary by database type — refer to the console for the options supported by your database. Click Submit Application. DMS redirects you to the ticket details page, where you can track the Basic Information and approval progress.
After the ticket is approved, the system runs the export task automatically. When the task completes, click Download Exported File on the ticket details page.
FAQ
Why does DMS show only 3,000 rows after I run an export?
The SQL Console has a query and export limit of 3,000 rows. To export more data, create a SQL Result Set Export ticket using the steps in Export SQL query result sets.