Bulk copy and bulk import and export techniques in Sql:
- The bcp utility: A command-line utility (Bcp.exe) that bulk exports and bulk imports data and generates format files.
- The OPENROWSET (BULK) function,
- The SQL Server Import and Export Wizard,
- The BULK INSERT statement: A Transact-SQL statement that imports data directly from a data file into a database table or nonpartitioned view.
- The SELECT INTO statement.