Configuring compression for SQL Server

You can configure Microsoft SQL Server compression options for PolicyCenter by using the <mssql-db-ddl> element of database-config.xml. Compression options can apply to the entire database, to specific tables, or to specific indexes of a table.

Note: You must have the Enterprise edition of SQL Server to have the SQL Server compression feature.

Refer to Microsoft SQL Server documentation for more information about SQL Server compression options.