The <mssql-table-compression> database configuration element

The <mssql-table-ddl> element in file database-config.xml contains, at most, a single occurrence of subelement <mssql-table-compression>. The use of the <mssql-table-compression> element is optional. Any value that you set at this level overrides that same value set at the global, database level. See also Configuring compression for SQL Server.

The <mssql-table-compression> element has the following syntax. The following code sample shows required attributes in bold font. 

<database>
  <upgrade>
    <mssql-db-ddl>
      <mssql-table-ddl table-name="string">     
        <mssql-table-compression index-compression="NONE|PAGE|ROW" table-compression="NONE|PAGE|ROW"/>
      </mssql-table-ddl>
    </mssql-db-ddl>
  </upgrade>
</database>

The following list describes the attributes that you can configure on the <mssql-table-compression> element. All of these attributes are optional.

index-compression

Specifies the index compression setting for the specified index. Valid values are:

  • NONE
  • PAGE
  • ROW

If not specified, PolicyCenter uses the database default.

table-compression

Specifies the table compression setting for the specified table. Valid values are:

  • NONE
  • PAGE
  • ROW

If not specified, PolicyCenter uses the database default.

The <mssql-table-ddl> element does not contain additional subelements.