topic Problem with projects pointing to an old database in ArcGIS Enterprise Questions https://community.esri.com/t5/arcgis-enterprise-questions/problem-with-projects-pointing-to-an-old-database/m-p/271911#M10433 <HTML><HEAD></HEAD><BODY><SPAN>We recently installed a new SQL Server and rebuilt our geodatabase. We repointed most of our user projects to the new database before the old one was switched off. However, we couldn't do all of them and some slipped through. The problem is that when a user opens one of these projects it takes an age for ArcMap to realise that the server is not there, and to load the project with the exclamation marks so we can repoint it.</SPAN><BR /><SPAN>Is there any way to get this process to speed up?</SPAN></BODY></HTML> Wed, 05 Jun 2013 13:52:47 GMT RebeccaWatson 2013-06-05T13:52:47Z Problem with projects pointing to an old database https://community.esri.com/t5/arcgis-enterprise-questions/problem-with-projects-pointing-to-an-old-database/m-p/271911#M10433 <HTML><HEAD></HEAD><BODY><SPAN>We recently installed a new SQL Server and rebuilt our geodatabase. We repointed most of our user projects to the new database before the old one was switched off. However, we couldn't do all of them and some slipped through. The problem is that when a user opens one of these projects it takes an age for ArcMap to realise that the server is not there, and to load the project with the exclamation marks so we can repoint it.</SPAN><BR /><SPAN>Is there any way to get this process to speed up?</SPAN></BODY></HTML> Wed, 05 Jun 2013 13:52:47 GMT https://community.esri.com/t5/arcgis-enterprise-questions/problem-with-projects-pointing-to-an-old-database/m-p/271911#M10433 RebeccaWatson 2013-06-05T13:52:47Z Re: Problem with projects pointing to an old database https://community.esri.com/t5/arcgis-enterprise-questions/problem-with-projects-pointing-to-an-old-database/m-p/271912#M10434 <HTML><HEAD></HEAD><BODY><SPAN>Use a Python script to repath the layers in your .mxds: </SPAN><A class="jive-link-external-small" href="http://resources.arcgis.com/en/help/main/10.1/index.html#/Updating_and_fixing_data_sources_with_arcpy_mapping/00s30000004p000000/" rel="nofollow" target="_blank">http://resources.arcgis.com/en/help/main/10.1/index.html#/Updating_and_fixing_data_sources_with_arcpy_mapping/00s30000004p000000/</A></BODY></HTML> Mon, 10 Jun 2013 21:47:44 GMT https://community.esri.com/t5/arcgis-enterprise-questions/problem-with-projects-pointing-to-an-old-database/m-p/271912#M10434 ChrisSnyder 2013-06-10T21:47:44Z Re: Problem with projects pointing to an old database https://community.esri.com/t5/arcgis-enterprise-questions/problem-with-projects-pointing-to-an-old-database/m-p/271913#M10435 <HTML><HEAD></HEAD><BODY><SPAN>You can manage your map documents (.mxd) in ArcCatalog. Navigate to the MXD in ArcCatalog then right click on it and you will be given a "Set Data Sources" option where you can update multiple connections at once. <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></SPAN></BODY></HTML> Thu, 27 Jun 2013 17:02:57 GMT https://community.esri.com/t5/arcgis-enterprise-questions/problem-with-projects-pointing-to-an-old-database/m-p/271913#M10435 RichardDaniels 2013-06-27T17:02:57Z