View Revisions: Issue #5146

Summary 0005146: Add an option to transform all columns with time zones when replicating to a non-time zone capable database
Revision 2022-07-25 16:29 by elong
Description When replicating columns that have time zones to a non-time zone capable database, there should be some kind of option to have this data automatically transformed before it is loaded into the target database. While this is already possible with transforms and/or load filters, it would be useful if SymmetricDS could detect this issue and transform the data accordingly without any additional configuration.

Source:
create table mytest (id integer, myts timestamp with time zone);

Target:
create table mytest (id integer, myts timestamp without time zone);
Revision 2021-12-09 16:42 by emiller
Description When replicating columns that have time zones to a non-time zone capable database, there should be some kind of option to have this data automatically transformed before it is loaded into the target database. While this is already possible with transforms and/or load filters, it would be useful if SymmetricDS could detect this issue and transform the data accordingly without any additional configuration.