Parallel Bulk Copy Syntax

Use this syntax for parallel bulk copy, when using several simultaneous sessions.

bcp table_name[:partition_number | partrition_name] in file_name
-Pmypassword
Alternatively, you can execute parallel bulk copy using a multithreaded version of bcp:
  • (UNIX) Perform this using the bcp_r command:
    bcp_r database_name..table_name partition partition_number1  
    [,  partition_number2 ...] in file_name1 [,file_name2 ....] 
    -U[username] -P[password] -S[servername]
  • (Windows) The standard bcp command is capable of paralled execution:
    bcp database_name..table_name partition partition_number1  
    [,  partition_number2 ...] in file_name1 [,file_name2 ....] 
    -U[username] -P[password] -S[servername]