Exporting Data to a Text File

You can export data for a given table to a text file. To do so:

From the Management Portal, select System Explorer, then SQL. Select a namespace by clicking the name of the current namespace displayed at the top of the page; this displays the list of available namespaces.
At the top of the main pane, click the Wizards drop-down list, and select Data Export.
On the first page of the wizard:
- Enter the complete path and filename of the file that you are going to create to hold the exported data.
- From the drop-down lists, select a Namespace, Schema Name, and Table Name from which you want to export the data.
- Optionally: if the file uses a Charset other than the system default, select it from the drop-down list.
Then click Next.
On the second page of the wizard, select which columns to export. Then click Next.
On the third page of the wizard, describe the format of the external file.
- For What delimiter separates your columns?, click the option corresponding to the delimiter in this file. If columns should be separated by a particular character, use the text box to specify the character.
- Click the Export column headers? check box if you want to export column headers as the first line of the file.
- For String quote, click an option to indicate how the file should indicate the start and end of strings.
- For Date format, click an option to indicate the format that the file should use for date values.
- For Time format, click an option to indicate the format that the file should use for time values.
- Optionally: click Preview Data to see what the results will look like.
Then click Next.
Review your entries and click Finish. The wizard displays the Data Export Result dialog box.
Click Close. Or click the given link to view the background tasks page.
In either case, the wizard starts a background task to do the work.