Use bcp to bulk-copy
compressed data in and out of tables.
Pages in a compressed table may have a combination
of row-compressed, page-compressed, or uncompressed rows. Even tables or partitions marked as uncompressed can include data that is a mixture of different
states of compression.
- bcp out – any compressed rows (including those with text data) are decompressed and
returned to the client, either in native or character form.
- bcp in – uncompressed data received from the client is compressed during the insert. bcp in selects the appropriate compression scheme, which depends on the compression level of the partition into which you are inserting the row.
When you bulk-copy data out (using bcp out), followed by a bcp in to a compressed table (or partition),
all newly loaded data is compressed, even when the extracted data was stored as uncompressed.
See Utility
Guide > Utility Commands Reference > bcp
dump database dumps compressed
data directly from disk to archive. If the transaction log contains
compressed LOB data, recover the compressed LOB data with load tran (see the System Administration
Guide: Volume 2 > Developing
a Backup and Recovery Plan).