You can use the bcp command-line utility to export a table or the result of a query to an external data file. You can copy this file over the network or the Internet, or use any media to send it to its destination. It also can be used to import the data file into a single table.
You can use the bcp native mode to export data to and from SQL Server databases. If you export data from SQL Server in native mode, you cannot import that data into any other database system than SQL Server. However, using character-based files provides better flexibility, because the data can be exported to any database system that supports importing from text files.
Using bcp in native mode, between SQL Server databases, is more ...