Welcome to Lesson 9 of the SQL Server 2000 Tutorial. In this lesson we will cover importing. I hope you enjoy the lesson.
Importing
Importing / Exporting
Importing and exporting data in SQL Server is accomplished using
two main tools, DTS and BCP, although you can also import and
export using SQL scripts, ODBC, and replication. Below is the
difference between DTS and BCP
|
Required functionality
|
DTS wizards |
bcp |
|
Import text data |
YES |
YES |
|
Export text data |
YES |
YES |
|
Import from ODBC data sources |
YES |
|
|
Export to ODBC data sources |
YES |
|
|
Import from OLE DB data sources |
YES |
|
|
Export to OLE DB data sources |
YES |
YES |
|
Graphical user interface (GUI) |
YES |
|
|
Command prompt/batch scripts |
YES |
YES |
|
Transact-SQL scripts |
|
|
|
Automatic scheduling |
YES |
YES |
|
Ad hoc import/export |
YES |
YES |
|
Recurring import/export |
YES |
YES |
|
Maximum performance |
|
YES |
|
Data transformation |
YES |
|
|
Programmatic interface |
YES |
YES |