How to Override Default Target Schema in Replication

Scenario

HVR creates the target table in the destination DBMS user’s default schema. It can happen that users want to override this default schema due to security or architectural reasons.

Steps

1. To change the target schema, add a new /TableProperties action to the channel as in the image below:

   

2. Existing integrate and refresh jobs should be recreated with Initialize and Refresh after this change.