The <mssql-db-ddl> database configuration element

The <upgrade> element in file database-config.xml contains, at most, a single occurrence of subelement <mssql-db-ddl>. The use of the <mssql-db-ddl> element is optional. Use this element to set SQL Server database DDL (Data Definition Language) options during the creation of new objects in the database. This configuration applies to the database at a global level.

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

<database>
  <upgrade>

     <mssql-db-ddl>
      <mssql-compression index-compression="NONE|PAGE|ROW" table-compression="NONE|PAGE|ROW/>
      <mssql-filegroups op="string" admin="string" typelist="string" staging="string" 
           index="string" lob="string"/>
      <mssql-table-ddl table-name="string">
        <mssql-index-ddl filter-where="string"index-compression="NONE|PAGE|ROW"
              index-filegroup="string" key-columns="string" partition-scheme="string"/>
        <mssql-table-compression index-compression="NONE|PAGE|ROW" table-compression="NONE|PAGE|ROW"/>
        <mssql-table-filegroups="string" index-filegroup="string" lob-filegroup
              table-filegroup="string"/>
      </mssql-table-ddl>
    </mssql-db-ddl>
  </upgrade>
</database>

There are no specific attributes on the <mssql-db-ddl> element.

The <mssql-db-ddl> element has the following subelements. Each of these elements is optional. There is, at most, a single occurrence of the <mssql-compression> and <mssql-filegroups> elements on the <mssql-db-ddl> element. There can be, however, multiple occurrences of the <mssql-table-ddl> element.

mssql-compression

Specifies compression settings for SQL Server  database tables and indexes at the global, database level. See The <mssql-compression> database configuration element for more information.

mssql-filegroups

Specifies the mapping between SQL Server database filegroups and PolicyCenter logical tablespaces at the global, database level. See The <mssql-filegroups> database configuration element for more information.

mssql-table-ddl

Specifies SQL Server database DDL options for a named table. These settings override values set at the global, database level. See The <mssql-table-ddl> database configuration element for more information.

See also