How to export 20 milion rows to only one file ?
How to export 20 milion rows to only one file ?
(OP)
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
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
RE: How to export 20 milion rows to only one file ?
go read the answer in https://www.sqlservercentral.com/forums/topic/how-...
Regards
Frederico Fonseca
SysSoft Integrated Ltd
www.syssoft-int.com
FAQ219-2884: How Do I Get Great Answers To my Tek-Tips Questions?
FAQ181-2886: How can I maximize my chances of getting an answer?
RE: How to export 20 milion rows to only one file ?
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.
https://duckduckgo.com/?q=bcp+in+sql+server
--Jeff Moden
-------------------------------------------------------------------------------
"RBAR" is pronounced "ree-bar" and is a "Modenism" for "Row By Agonizing Row"