Does compressed data stay compressed in transactional replication SQL 2008 R2

• Express12

  SSCoach

  Points: 18514

  More actions

  July 16, 2013 at 5:58 am

  #277429

  Does compressed data stay compressed in transactional replication SQL 2008 R2?

  We are planning on using transactional replication to replicate SQL 2008 R2 (sp2) compressed data to another SQL 2008 R2 (sp2) sql server.

  Are there any settings I need to make on the published article to retain the compressed data?

  BT

• dbafromthecold@gmail.com

  SSChampion

  Points: 10160

  More actions

  July 16, 2013 at 6:16 am

  #1632831

  Hi, compression is an attributed which is replicated. Please have a look here:-

  http://msdn.microsoft.com/en-us/library/cc280449.aspx

  Andrew

• Express12

  SSCoach

  Points: 18514

  More actions

  July 16, 2013 at 7:52 am

  #1632875

  Andrew - thank you. Using your link, I successfully tested this.

  Using transactional replication (SQL 2008 R2 sp2 to SQL 2008 R2 sp2, I set up a publication w/ 1 article.

  I had to manually change the ‘copy data compression attribute’ from False to True.

  I checked the published target table and it was compressed!

  BT