Skipping migration of column DEFAULT clause v7
Use cases
The subscription database is in read-only mode. Therefore, DEFAULT clause columns serve no purpose as they are already applied on the publication database. You can skip migrating DEFAULT columns for faster processing.
Sequences aren't migrated during replication operations. If a DEFAULT clause depends on a sequence, the DEFAULT clause migration will fail. You can skip migrating DEFAULT columns to avoid migration failures.
Configuration
To skip the replication of a DEFAULT clause, set the following option to true:
By default, this option is disabled (skipColDefaultClause=false
).
Note
This option applies only to the subscription server.
- On this page
- Use cases
- Configuration