Exporting a table with BCP
An example of exporting a table with the bcp command-line utility: integrated authentication (-T) and native format (-n) for SQL Server.
An export example
bcp mydatabase.dbo.mytable OUT mytable.bcp -T -n
| Option | Meaning |
|---|---|
-T | Integrated authentication |
-n | Native format, for importing back into SQL Server |