Tools - Export Tool
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.
2. The first tab in the wizard 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
|
Export Tool Enhancement
The Export Tool now has an option to indicate the Date quote identifier for the output results. |
|
