How to export 20 milion rows to only one file ?

[ahmedsa2018]

I work on sql server 2019 i have table have 20 milion rows .

i need to export data Exist on table to only one file by using sql server 2019 .

so what best tool and faster tool can help me to extract 20 milions rows from sql server to csv file (only one file )

and on same time is good for performance

 

[fredericofonseca]

you already had an answer on other forums - why do you post the same question in here?
go read the answer in

https://www.sqlservercentral.com/forums/topic/how-to-export-20-milion-rows-to-only-one-file

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

FAQ219-2884
FAQ181-2886

 

[JeffModen]

Like I said on the post that Frederico posted, use BCP. Read up on the "CSV" option they came out with in 2017.

For anyone else interested, here's the link I provided to the MS Documentation on the subject. The first article to show up is the documentation on BCP. The second article is one on how to use it.

[URL unfurl="true"]https://duckduckgo.com/?q=bcp+in+sql+server[/url]

--Jeff Moden
-------------------------------------------------------------------------------
"RBAR" is pronounced "ree-bar" and is a "Modenism" for "Row By Agonizing Row