We are moving a Federated Enterprise 11.3 setup on multiple servers to all roles on one server and one MS SQL server.

Question

All has been installed and federated on one server and I just need to connect to the SQL server. I'm curious if possible to simply restore the SQL DBs from the current SQL server then connect? There are three DBs, GISProd, GISWip, and GISWip-2. I'm thinking not because of the different infrastructures and URLs. Also, would anyone know if these are ArcGIS default DBs? I'm a sys admin and just build and manage the servers and do not work with ArcGIS Pro though do have it installed if needed. I want to make sure the foundation is all good before working on the migration part of the project.

RoyRivas · Answer

Hello @JakeSkinner

I just reached out to Esri and will see if they can assist. The high level steps you provided are very helpful and greatly appreciated. Thank you!

JakeSkinner · Answer

@JeffK there are a lot of steps involved.  I would recommend assistance from Esri, or a possibly a business partner.  At a high level the steps are:

* Backup databases
* Restore databases to new SQL instance
* Re-sync database users
* Update existing Pro projects to reference new instance (recommend python script)
* Update ArcGIS Server Data Store connections
* Optionally, update the ArcGIS Server service's metadata

JeffK · Answer

Hi @JakeSkinner,

Thanks much for the information. We are moving to a new SQL server and name so I'll follow the steps mentioned. Before I do, will I need to backup/restore the current database to the new SQL instance or will ArcGIS Pro and the process create a new database, then the GIS analysts can move there projects to it?