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

[JeffK]

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.

[JakeSkinner]

Hi @JeffK,

Are you moving SQL Server to a new server as well?   If so, I'm assuming the server name is new, and therefore the SQL instance name is different.  In ArcGIS Pro, you'll need to update the database connections to use the new instance.  In Enterprise, you'll need to update the Data Store connections with a database connection file that is referencing the new SQL instance.

[JeffK]

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? 

[JakeSkinner]

@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:

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

[RoyRivas]

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!