none
Subscriptions in SQL 2012

    Question

  • Can a table that has a Columnstore index on it have a replication subscription to it?
    Thursday, September 19, 2013 3:57 PM

Answers

  • According to Columnstore Indexes, they cannot be combined with Replication.

    Columnstore indexes cannot be combined with the following features:

    • Page and row compression, and vardecimal storage format (A columnstore index is already compressed in a different format.)

    • Replication

    • Change tracking

    • Change data capture

    • Filestream


    Brandon Williams (blog | linkedin)

    • Marked as answer by dbSlave65 Thursday, September 19, 2013 4:17 PM
    Thursday, September 19, 2013 4:12 PM

All replies

  • According to Columnstore Indexes, they cannot be combined with Replication.

    Columnstore indexes cannot be combined with the following features:

    • Page and row compression, and vardecimal storage format (A columnstore index is already compressed in a different format.)

    • Replication

    • Change tracking

    • Change data capture

    • Filestream


    Brandon Williams (blog | linkedin)

    • Marked as answer by dbSlave65 Thursday, September 19, 2013 4:17 PM
    Thursday, September 19, 2013 4:12 PM
  • Thanks for the Info
    Thursday, September 19, 2013 4:16 PM