topic ArcGis data replication using Oracle replication technologies in ArcGIS Pro Questions

ArcGis data replication using Oracle replication technologies

MuhamedHarisMuhamed — Thu, 14 Apr 2022 08:23:30 GMT

Hi Support ,

We are using ArcGIS pro with Oracle database , and we are planning to have a new database server for web application to reduce the usage in production database , Kindly advice Which is the best solution for the replicate the real time data from production database to the application database .

Any one have experienced with Giodatabase synchronization with Oracle golden gate ?

regards

Haris Palliyal

Re: ArcGis data replication using Oracle replication technologies

AlisonWieckowicz — Wed, 26 Feb 2025 20:46:37 GMT

I see that this post is from 2022 but I curious what outcome you had when evaluating bidirectional replication of GDB with golden gate. We too considering similar options.

There is a lot that concerns me with true bidirectional active/active replication of a geodatabase. I was told that primary keys aren't required as long as you could uniquely identify a row. How would global IDs be ensured to be unique if sde.next_rowid could be executed by either DB simultaneously.

Am I over thinking this?