What would happen if you enable data compression (either row or page-level) on a replicated table (merge replication) where the publisher is SQL 2008 Enterprise (Supports data compression) and the subscriber was SQL 2008 Standard (does not support data compression). Would the compression attribute get politely dropped and the subscriber continues happily not-compressed or would it cause replication to hit an error and stop?
Sql-server – SQL 2008 Merge Replication and table-level data compression
compressionsql server
Related Question
- Sql-server – SQL Server merge replication across domains
- Sql-server – How to properly troubleshoot Merge Replication False Conflicts
- Sql-server – How to manually invalidate a pull merge replication snapshot from the publisher
- Sql-server – SQL Server 2014 Transactional Replication Partition Switching
- Sql-server – Two-step Replication between SQL 2008 and 2017
- Sql-server – MS SQL Server: Transactional replication not working but no errors are present
Best Answer
It will fail if you try to save replicate including compression, but if you set it to only "replicate the partition scheme but not compress the data on the Subscriber."
Source : http://msdn.microsoft.com/en-us/library/cc280449.aspx
Following from that, what happens when you restore a backup from sql 2008 enterprise with some table compression enabled, onto a sql 2008 standard server instance.. I've not actually tried and it's an interesting concept.