Import and export with BCP
How to import and export table data with BULK COPY.
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 |
bcp mydatabase.dbo.mytable OUT mytable.bcp -T -n
| Option | Meaning |
|---|---|
-T | Integrated authentication |
-n | Native format, for importing back into SQL Server |