Configuration options for SQL Server filegroups

To specify filegroups for SQL Server, use the following syntax in your database configuration in database-config.xml.

<database>
...
  <upgrade>
    <mssql-db-ddl> 
      <mssql-filegroups admin="admin filegroup" index="index filegroup" op="op filegroup"
       staging="staging filegroup" typelist="typelist filegroup" lob="lob filegroup" />
    </mssql-db-ddl>
  <upgrade>
</database>

To specify filegroups for a particular table in SQL Server, use the following syntax in your database configuration in database-config.xml.

<database>
...
  <upgrade>
    <mssql-db-ddl> 
      <mssql-filegroups admin="admin filegroup" index="index filegroup" op="op filegroup"
       staging="staging filegroup" typelist="typelist filegroup" lob="lob filegroup" />
      <mssql-table-ddl table-name="table name">
        <mssql-table-filegroups table-filegroup="table filegroup" lob-filegroup="LOB filegroup"
         index-filegroup="index filegroup"/>
      </mssql-table-ddl>
    </mssql-db-ddl>
  </upgrade>
</database>