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

Introduction

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

Overview

This issue can be caused by the differences in the timezone settings of the source and target databases.

Resolution

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.