idea Make Updating Database References for services easier when doing Disaster Recovery in ArcGIS Enterprise Ideas https://community.esri.com/t5/arcgis-enterprise-ideas/make-updating-database-references-for-services/idi-p/1337394 <P>Our organization is completely in the AWS cloud.</P><P>We do regular Disaster Recovery exercises.</P><P>Enterprise Servers are on windows aws ec2s instances.</P><P>Our enterprise Databases are in postgres aurora (aws database as a service).</P><P>&nbsp;</P><P>When we stand up a copy of our ESRI prod enterprise in our DR region, all the GIS services referencing SDE database break, since all the database references are pointing to the PROD env.</P><P>&nbsp;</P><P><STRONG>The idea here is to find fast and easy way to update all these services to point to the DR database instance.</STRONG></P><P>&nbsp;</P><P>Current Process ESRI recommends (<STRONG>Not a very customer friendly way</STRONG><span class="lia-unicode-emoji" title=":disappointed_face:">😞</span></P><OL><LI>Register DR datastore&nbsp;</LI><LI>Republish or overwrite each service so the database reference can be updated.&nbsp;</LI></OL><P>&nbsp;</P> Thu, 12 Oct 2023 17:32:32 GMT DanielSalazar2 2023-10-12T17:32:32Z Make Updating Database References for services easier when doing Disaster Recovery https://community.esri.com/t5/arcgis-enterprise-ideas/make-updating-database-references-for-services/idi-p/1337394 <P>Our organization is completely in the AWS cloud.</P><P>We do regular Disaster Recovery exercises.</P><P>Enterprise Servers are on windows aws ec2s instances.</P><P>Our enterprise Databases are in postgres aurora (aws database as a service).</P><P>&nbsp;</P><P>When we stand up a copy of our ESRI prod enterprise in our DR region, all the GIS services referencing SDE database break, since all the database references are pointing to the PROD env.</P><P>&nbsp;</P><P><STRONG>The idea here is to find fast and easy way to update all these services to point to the DR database instance.</STRONG></P><P>&nbsp;</P><P>Current Process ESRI recommends (<STRONG>Not a very customer friendly way</STRONG><span class="lia-unicode-emoji" title=":disappointed_face:">😞</span></P><OL><LI>Register DR datastore&nbsp;</LI><LI>Republish or overwrite each service so the database reference can be updated.&nbsp;</LI></OL><P>&nbsp;</P> Thu, 12 Oct 2023 17:32:32 GMT https://community.esri.com/t5/arcgis-enterprise-ideas/make-updating-database-references-for-services/idi-p/1337394 DanielSalazar2 2023-10-12T17:32:32Z