The copy table fails with "Cannot copy vertically partitioned table tablename" (4330732)

The copy table fails with "Cannot copy vertically partitioned table tablename"

When attempting to copy a table that is involved in a vertically partitioned replication, the following errors appear on the screen:

sp_ctrl (source_server:port_num)> copy owner.table2

Cannot copy vertically partitioned table owner.TABLE2
The whole table can be done using the force option after the target table has been dropped
Once the copy is complete, drop any columns in the target table that should not exist
Use of the force option on a table in replication may cause out-of-sync conditions

The active config has the table replicating in a vertically partitioned manner:

sp_ctrl (source_server:port_num)> view config config_name

datasource:o.source_SID

#source tables target tables routing map
owner.table2 (num_col) owner.table2 (num_col)target_server@target_SID


The error also shows up when using append table.

Shareplex does not support theuse of the copy table for a table that is involved in a vertically partitioned replication.

The workaround is:

1.Drop the target table.
2.Use the force option to copy, namely copy owner.table2 force
3.Once the copy is complete, you can drop any columns in the target table that you do not wish to be there.

As the above message from the sp_ctrl implies, the use of force option on a table in replication may cause out-of-sync conditions.

The Shareplex Reference Guide has the following section that mentions that the copy or append is not supported for Vertically Partitioned replication and one may have to use the above workaround if using copy on such tables:

What the copy/append command does not support
.
.
Tables in replication that are horizontally or vertically partitioned.
.
.