These examples show the copying of data from bigtable, which is partitioned three ways: ptn1, ptn2, and ptn3, to various operating system files.
This example copies the data in bigtable to file1:
bcp mydb..bigtable out file1
This example copies the data from ptn1, ptn2, and ptn3 to file2:
bcp mydb..bigtable partition ptn1, ptn2, ptn3 out file2
This example copies the data from ptn1 and ptn2 to data files ptn1.dat and ptn2.dat:
bcp mydb..bigtable partition ptn1, ptn2 out ptn1.dat, ptn2.dat
This example also copies the data from ptn1 and ptn2 to ptn1.dat and ptn2.dat. Enter:
bcp mydb..bigtable partition ptn1, ptn2 out
See Chapter 1, “Utility Commands Reference,” for complete syntax and usage information for bcp.
