How to run copy to sync tables at schema level (4298848)

How to run copy to sync tables at schema level

How to run copy to sync tables at schema level.

General information.

There is no such feature as schema level copy. However, you can create a dummy config file containing all objects from that schema (in /vardir/config directory), and use the command "copy using <dummy_config_name>" to sync up that schema.

You can use the script build_config.sql to create such dummy config file. Please refer to Shareplex Administrator Guide Chapter titled “Preparing for SharePlex Replication” section titled “Scripting a configuration to replicate numerous tables in a schema” for further details. The workaround will not work on the HA or peer-to-peer environment (that is, two way replication) as messages for Import will loop back to the primary. For details on running copy, please refer to Shareplex Reference Guide.