How to export 20 milion rows to only one file ?

ahmedsa2018 · Sep 20, 2022

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 · Sep 21, 2022

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 · Dec 18, 2022

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

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

How to export 20 milion rows to only one file ?

ahmedsa2018

Programmer

fredericofonseca

IS-IT--Management

JeffModen

Programmer

Similar threads

Part and Inventory Search

Sponsor