Home Forums SQL Server 2012 SQL Server 2012 - T-SQL BCP Export Limitation of 1000 rows RE: BCP Export Limitation of 1000 rows

  • November 23, 2015 at 6:35 am

    #1841685

    serg-52 (11/23/2015)

    Using SQL generate a rowset containing all needed bcp commands and save it to a file.

    Create vbscript kind of https://gallery.technet.microsoft.com/scriptcenter/32e0146a-83fc-4ee1-af7b-52a57d57466c to run commands from file in parallel using WScript.Shell's Exec method.

    Same can be achieved with powershell i suppose.

    Hey thanks, I am looking at the VB code they provided, however it might be suitable for multiple tables.

    Lets' say if you have a single table of 100 GB, a normal bcp would be churning out very low number of rowsand exporting it may take very long. I tried using single bcp and it took 24 +hours for my table. I realized by looking at my SQL Server activity monitor that the bcp was not causing high resource utilization and windows resource monitor proved it too. The Database I\O never exceeded 4-6 MB\sec.

    So I am looking to reproduce the magic that SQL Server snapshot agent does while configuring replication and taking the snapshot, and boy, that is fast!!