How To: Override the default target schema in a 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:
Step 1] To change the target schema, add a new /TableProperties action to the channel as on the picture below:
Step 2] Existing integrate and refresh jobs should be recreated with HVR Initialize and HVR Refresh after this change.