Our organisation has ESRI Enterprise with an onsite Portal for ArcGIS. We are looking to migrate one or more of our RDBMS (PostgreSQL) SDE databases to a new server, and therefore a new hostname. Is there a method for performing such a migration without severing links to ArcGIS Server / Portal? Can the hostname be updated in bulk (perhaps in the Data Store sources somehow), as all other references will remain the same (the database and registrations will be backup / restored with the same values)? Otherwise is it a case of republishing all services (which seems a little cumbersome)?
Edit 1: I guess I need to add a new data store (pointing to the new host) and update the services so they look at this new data store (this would not be every service on our ArcServer). Is there a way of doing this?
Edit 2: I have noticed on looking in the data store it is possible to 'Edit Database Connection', so will test if keeping the 'Name' the same but changing the 'Publisher Database Connection' alters associated services to this Data Store to point to the new location.
Edit 3: Attempting to alter the 'Publisher Database Connection' did not work, an unhelpful error icon was displayed without details. I then tried updating the 'Server Database Connection', restarted the web service, and it is now reading the data from the new host. This is useful, as I can edit all our Data Store RDBMS connections and it will en masse change the service sources. This will be useful in the future when we want to divide our RDBMS onto further servers in order to increase redundancy and improve query performance as we scale users.
