This documentation is for an older version of HVR.

How to Override Default Target Schema in Replication

Question

How can I override the default target schema in replication?

Environment

HVR 5

Answer

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

To change the target schema, add a new /TableProperties action to the channel as in the image below:
Existing integrate and refresh jobs should be recreated with Initialize and Refresh after this change.