I have a Pro project with 16 maps that each contain 6 layers. All of the layers are query layers pulling data from the same SQL database. Next month, the database is going to be moved to a production server, which means that I need to change the connection that all 96 layers use. Needless to say, I am not looking forward to that many clicks! Is there something in the arcpy library that I could use to script out the process of repointing these layers? I've never used a script to modify a Pro project before, so I'm mainly looking for ideas on where to start.
