Database compression includes limitations on replicating compressed data and in-memory databases.
- Generally, compression is restricted for in-memory databases. Loading and
recovering compressed objects in disk-resident or relaxed-durability
in-memory databases is permitted. However, access to compressed objects in
the target in-memory database is often restricted. Minimal support is
provided for disabling compression in the target database or in tables
defined for compression, so you may revert to using uncompressed data.
- Compressed LOB columns do not support replication. Issue the following to indicate that a column is not to be replicated before you compress columns with LOB data that are part of a replicated database:
sp_setrepcol table_name, lob_column_name, 'do_not_replicate'
See the Replication Server Reference Manual.