12.2 How to Export Data using ADS (Revision #14)

The Export Tool allows data from databases, tables and other database objects to be exported in a variety of formats.

1. Select Tools->Export Data from the Menubar. This will prompt the user to choose a server from which to export data. He/she may then navigate, select the server and click ok. This will bring up the Export dialog. It is also possible to right click on items in the Schema Browser and select Tools->Export Data.

2. The first tab in the Export Data Dialog is the General Tab. In this section the user must specify the source of the data to be exported. The first option is to specify a table to export which will export the contents of the table. The next choice is to specify a SELECT statement of which the results will be exported. If the he/she specifies a SELECT statement, then he/she must also select a database in the database combo box in which the statement will be executed.

3. In the Options Tab, the user may first begin by browsing and selecting a file location in which to save the exported data. The user may then specify the encoding and platform into which the file will be saved. One of two formats may be specified: delimited data or Insert statements. When the user specifies delimited data, he/she chooses the delimiter, quote identifier, NULL value and whether to include the column names as the first of the export. When he/she chooses the INSERT statement format, the user can execute later in the Query Analyzer.

4. Once in the Status Tab the export has begun. The user may cancel the export at any time by clicking on the cancel button at the bottom of the dialog. If any errors or warnings occur, they will be displayed in the message text window.

Date and time formats are specified by date and time pattern strings. Within date and time pattern strings, unquoted letters from ’A’ to ’Z’ and from ’a’ to ’z’ are interpreted as pattern letters representing the components of a date or time string. Text can be quoted using single quotes (’) to avoid interpretation. "’’" represents a single quote. All other characters are not interpreted; they are simply copied into the output string during formatting, or they are matched against the input string during parsing.

Letter	Date or Time Component	Presentation	Examples
`G`	Era designator	Text	`AD`
`y`	Year	Year	`1996`; `96`
`M`	Month in year	Month	`July`; `Jul`; `07`
`w`	Week in year	Number	`27`
`W`	Week in month	Number	`2`
`D`	Day in year	Number	`189`
`d`	Day in month	Number	`10`
`F`	Day of week in month	Number	`2`
`E`	Day in week	Text	`Tuesday`; `Tue`
`a`	Am/pm marker	Text	`PM`
`H`	Hour in day (0-23)	Number	`0`
`k`	Hour in day (1-24)	Number	`24`
`K`	Hour in am/pm (0-11)	Number	`0`
`h`	Hour in am/pm (1-12)	Number	`12`
`m`	Minute in hour	Number	`30`
`s`	Second in minute	Number	`55`
`S`	Millisecond	Number	`978`
`z`	Time zone	General time zone	`Pacific Standard Time`; `PST`; `GMT-08:00`
`Z`	Time zone	RFC 822 time zone	`-0800`

The following examples show how date and time patterns are interpreted in the U.S. locale. The given date and time are 2001-07-04 12:08:56 local time in the U.S. Pacific Time time zone.

Date and Time Pattern	Result
`"yyyy.MM.dd G ’at’ HH:mm:ss z"`	`2001.07.04 AD at 12:08:56 PDT`
`"EEE, MMM d, ’’yy"`	`Wed, Jul 4, ’01`
`"h:mm a"`	`12:08 PM`
`"hh ’o’’clock’ a, zzzz"`	`12 o’clock PM, Pacific Daylight Time`
`"K:mm a, z"`	`0:08 PM, PDT`
`"yyyyy.MMMMM.dd GGG hh:mm aaa"`	`02001.July.04 AD 12:08 PM`
`"EEE, d MMM yyyy HH:mm:ss Z"`	`Wed, 4 Jul 2001 12:08:56 -0700`
`"yyMMddHHmmssZ"`	`010704120856-0700`