In these examples, we are copying data from bigtable, which is partitioned three ways: ptn1, ptn2, and ptn3, to various operating system files.
To copy the data in bigtable to file1, enter:
bcp mydb..bigtable out file1
To copy the data from ptn1, ptn2, and ptn3 to file2, enter:
bcp mydb..bigtable partition ptn1, ptn2, ptn3 out file2
To copy the data from ptn1 and ptn2 to data files ptn1.dat and ptn2.dat, enter:
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 7, “Utility Commands Reference,” for complete syntax and usage information for bcp.
