I have 52 Map Services running from 52 MXDs (each with multiple Feature Classes). When certain Feature Classes inside our Enterprise Geodatabase (SQL Server 2008 R2) get updated (which done weekly), I push these updates into our Replica File Geodatabase using Distributed Geodatabase (a one-way replica). Then I open each MXD and begin the process of updating each Map Service.
All our Map Services run off of our Replica File Geodatabase.
It is very time consuming (understatement!) to have to go through each of these MXDs and Share As - Overwrite to update each of our Map Services one-by-one. Is there a way to automate this process, so when the Replica Geodatabase is updated, the Map Services automatically get updated as well?
I cannot consolidate all into a few MXDs. It is the nature of the inside of a Wastewater Treatment Plant that the complexity therein demands we have lots of MXDs.
We are using ArcGIS 10.2.2 (Desktop Advanced and Server Enterprise).