Term
| Bulk Copy program (BCP.exe): |
|
Definition
the most efficient way to
import well-defined data in files into SQL Server or to export tables to a file |
|
|
Term
| If you need to perform transformations or error-handling routines during import/export, use _______ |
|
Definition
|
|
Term
| ______has limited error correction |
|
Definition
|
|
Term
|
Definition
At end of session, you are asked to save your responses in a file,
called a format file
Can use the format file in another session by setting the –f switch |
|
|
Term
|
Definition
a T-SQL command for importing
data into a database
Cannot export data
Does not need to specify the instance name or login credentials |
|
|
Term
| what's faster, Bulk Insert or BCP |
|
Definition
BULK INSERT works from within SQL Server instance and
is faster than BCP |
|
|
Term
| set DB recovery model to ______ before using BULK INSERT |
|
Definition
|
|
Term
| Bulk Insert, set a _______ on the bulk load value |
|
Definition
|
|
Term
| SQL Server Import & Export Wizard: |
|
Definition
Can use any data source recognized by SSIS, including MS Office
files or XML files
Supports any data source or destination accessible through an
OLE DB provider
Does not required a SQL Server instance as source or target
Can move data from multiple tables or files in a single operation |
|
|
