BCP-using fifo files
时间：2009-06-15 来源：qiaodan211
Using fifo files in bcp out/in files, it can speed up the operation as no bcp files need to create.
Sampel:
mkfifo myfifo
bcp DB1..TableA out myfifo -SServer -Uusername -Ppass -n -b 10000 -A 16384 >bcpout.out 2>bcpout.err
& bcp DB2..TablesB in myfifo -SServer -Uusername -Ppass -n -b 10000 -A 16384 >bcpin.out 2>bcpin.err
bcp DB1..TableA out myfifo -SServer -Uusername -Ppass -n -b 10000 -A 16384 >bcpout.out 2>bcpout.err
& bcp DB2..TablesB in myfifo -SServer -Uusername -Ppass -n -b 10000 -A 16384 >bcpin.out 2>bcpin.err
相关阅读 更多 +
