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:

skipColDefaultClause=true

By default, this option is disabled (skipColDefaultClause=false).

• On this page
• Use cases
• Configuration