Export Tool
1. Select Tools->Export Data from the Menubar. This will prompt you to
choose a server in which to export data from. Navigate and select your
server and click ok. This will bring up the Export dialog
2. The first tab in the wizard is the General Tab. In this section you 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 other choice is to specify a SELECT statement of which the results
will be exported. If you specify a SELECT statement, then you must also select a database in the
database combo box in which the statement will be executed.
3. In the Options Tab you may first begin by browsing and selecting a file location to save the
exported data. Then specify the encoding and platform to save the file in. You may specify
one of two different formats. You may specify the format as delimited data, and then specify the
delimiter, quote identifier, NULL value and whether to include the column names as the first row
of the export. Or you may specify the format as INSERT statements which later may be executed in
the Query Analyzer.
4. Once in the Status Tab the export has begun. You 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're simply copied into the
output string during formatting or 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
| |
|
