Reply To: How to replicate SQL Server geometry datatype

#12269
Björn Bengtsson
Participant

The example shows how to transform a geometry column from a source to a target. How do I setup a bidirectional replication that also replicates from the target to the source? I have tried to create the same actions but the other way around but then HVR shows the following error during “HVR Initialize”:

F_JR0324: Parameter /CaptureExpression has conflicting values for table ‘t1’ and location ‘rqsrc’. The conflicting actions are ColumnProperties /Name=geom1 /CaptureExpression=geom1.ToString() /IntegrateExpression=geometry::STGeomFromText({geom1},0) in the definition of channel ‘rqm_src_tgt’, group ‘RQMSRC’ and table ‘t1’ and ColumnProperties /Name=geom1 /Absent /CaptureExpression=”select t.geom1.ToString() from t1 t where t.id={id}” /Context=!refresh in the definition of channel ‘rqm_src_tgt’, group ‘RQMSRC’ and table ‘t1’.

© 2020 HVR

Test drive Contact us