FILEGROUP

Valid For

For SQL Server only.

Description

Overrides the default database filegroup (PRIMARY) when adding TRANDATA to tables and creating the SQL Server CDC capture tables on the designated filegroup.

The filegroup must exist in the database and have a valid database file attached to it. The GLOBALS FILEGROUP parameter can be overwritten by the following statement, if required, but this is not normally necessary:

ADD TRANDATA schemaname.tablename FILEGROUP filegroupname

If the FILEGROUP parameter exists in GLOBALS, then the ADD HEARTBEATTABLE command also creates the SQL Server CDC capture tables for the heartbeat tables on the designated filegroup.