SQLCMD vs BCP Export performance? RRS feed

  • Question

  • Hi,

    Anyone know which is better at performance for Export to csv file using SQLCMD VS BCP ? 

    Any reference to any article or comparison statistics if possible.

    I need automate multiple tables with millions of records to be exported on daily basis and need to know which option is better to use. The tables list is dynamic, so cannot use SSIS - DFT.

    Thanks in advance.


    • Edited by Mahesh Dasari Thursday, June 15, 2017 1:40 AM grammer
    Thursday, June 15, 2017 1:34 AM

All replies