Thanks Bruce but the data contains 1000s of records containing confidential tenant information. I doubt I'd be allowed to share
In an ideal world, I just need a simple script that deletes the existing dataset and places the new, updated dataset in the same directory and with the same name. That way all the MXDs won't need to be re-sourced each time.
The reason I can't do this method is because of an ever present LOCK file on the existing dataset (it's under constant access by our GIS server...).
Maybe a script that says:
1. Stop Server GIS service
2. Delete Points.shp
3. Create updated version of Points.shp in same directory with same name.
4. Start Server GIS service