You can export data for a given class 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 page, 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 select a character set from the Charset drop-down list; the default is Device Default.
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.
-
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 to start and end string data in this file.
-
For Date format, click an option to indicate the date format to use in this file.
-
For Time format, click an option to indicate the time format to use in this file.
-
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.