Exporting big data to TXT/CSV file using line command BCP to connect a MS SQL Server

 Hi my friends!

Exploring the BCP line-command from Microsoft SQL Server, using Windows Authentication, is very efficient exportation to .csv/.txt format, for extensive data volumes. I'm very impressive about performance returned, when extracted big volumes to a file.

Comand used on powershell:

bcp "SELECT * FROM [dbo].[YourTable]" queryout "C:\Temp\Exported_Data.csv" -S localhost -d DataBaseName -T -c

This is a very good tool to work with extensive data exportation.