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, Adaptive Server often restricts access to compressed objects in the target in-memory database. Adaptive Server provides minimal support 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.