I really like the idea of geodatabase replication, and one idea we've had recently is to replicate our production data to a separate geodatabase specifically used for web services. Our production data is in a local State Plane coordinate and we'd like our web environment to be in Web Mercator so that no projection has to be done on the data in order to overlay on Esri standard base maps.
I am aware of this Esri technical article that provides a workflow for initially creating the replica, and it works as expected.
However, I'd like to automate the process of synchronizing our replicas using Python. When I test this workflow, edits pushed from production to the web replica do not seem to take into account any type of transformation, and when the web replica is overlaid with the production data, you can see the NAD83 and WGS84 datum shift (screenshot below).
Is there any way to account for the datum transformation when automating the replica synchronization? Having to manually sync the replica using tools within ArcMap really isn't a feasible option for us.
Blue features = production data in NAD83 State Plane
Red features = replicated data in WGS84 Web Mercator
The shifted red features are those that were added AFTER the replica was created and then synchronized.