I would like to schedule nightly updates to a field in one feature class on SDE based on edits made by editors during the day. However, I am unsure about the workflow.
GIS editors create a version for themselves at the beginning of the week. Post/Reconcile of versions occurs every evening. Compression and deletion of versions happens on weekends. I was planning on scheduling this task after the nightly Post/Reconcile.
My question is: If I use our GDB Owner connection file in the model, does it edit the SDE default version directly? Or do I need to specify a version somehow in the model? If it edits the Default SDE version directly, will this conflict with the edits made during the day by our GIS editors?
I have tested the model and it works. The model I would like to run on a nightly schedule would do the following: