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.