The <mssql-compression> database configuration element

The <mssql-db-ddl> element in file database-config.xml contains, at most, a single occurrence of subelement <mssql-compression>. The use of the <mssql-compression> element is optional. Use this element to set SQL Server database compression options at the global, database level. See also Configuring compression for SQL Server.

The <mssql-compression> element has the following syntax.

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

The following list describes the attributes that you can configure on the <mssql-compression> element.

index-compression

If present, specifies the index compression setting for all indexes. Valid values are:

  • NONE
  • PAGE
  • ROW

The default is NONE.

table-compression

If present, specifies the table compression setting for all tables. Valid values are:

  • NONE
  • PAGE
  • ROW

The default is NONE.

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

See also