Brief about Bulk copy with an example.
- Bulk copy utility of SQL allows data to be copied from one data file to another.
- The data is first exported from the source data file and then imported into the SQL server using the bcp command.
- It can also be used to transfer data from a table to a file.
- It can be used to write data only to SQL server tables.
- The SqlBulkCopy contains an instance method WriteToServer which is used to transfer the data from the source to the destination.
Syntax:public void WriteToServer
(
DataTable table
)
