Administering SQL Server
Copying Data
There are six options for copying data using bcp or BULK INSERT.
| Topic | Description |
|---|---|
| Copying Data Between Servers | Describes which data format to use when copying data between instances of Microsoft® SQL Server™. |
| Copying Data from a Data File to SQL Server | Describes how to copy data from a data file to an instance of SQL Server, including how to handle identity values and image data. |
| Copying Data From a Query to a Data File | Describes how to copy the result set from a Transact SQL statement to a data file. |
| Copying Data To or From a Temporary Table | Describes how to copy data to or from a temporary table. |
| Copying Data To or From a View | Describes how to copy data to or from a view. |
| Copying Data Between Different Collations | Describes how to copy data between different collations, including the use of column-level collations. |