This documentation is for an older version of HVR.

How to Fix Date Value Replication Issues Between Ingres, Oracle, and SQL Server

Question

How can I resolve the date replication issue between Ingres, Oracle, and SQL Server where the date values differ by a few hours?

Environment

HVR 5

Answer

This can be fixed by adding action Environment with the parameters /Name=TZ /Value="TIMEZONENAME", where "TIMEZONENAME" should be replaced with the required time zone (e.g. GMT or Europe/Amsterdam).

Both replication jobs and refresh and compare are affected by this.