If ASE supports encrypted columns, BCP supports bulk copying of encrypted columns. When encrypted columns is supported, bcp sends the following SQL command: set ciphertext on.
The encrypted data is obtained in cipher text instead of plain text.
A new parameter -C is included to support BCP encrypted columns. -C enables the ciphertext option before initiating the bulk copy operation, if Adaptive Server supports encrypted columns.
In the following example, the -C parameter copies data out of the publishers table (with encrypted columns) in cipher-text format, instead of plain text. Pressing Return accepts the defaults specified by the prompts. The same prompts appear when copying data into the publishers table:
bcp pubs2..publishers out pub_out -C
Password:
Enter the file storage type of field col1 [int]:
Enter prefix length of field col1 [0]:
Enter field terminator [none]:
Enter the file storage type of field col2 [char]:
Enter prefix length of field col2 [0]:
Enter length of field col2 [10]:
Enter field terminator [none]:
Enter the file storage type of field col3 [char]:
Enter prefix length of field col3 [1]:
Enter field terminator [none]: