SDE - Enterprise Geodatabase Relocation to New Server

[JD1016]

Hello,

Is it possible to copy SDE Enterprise Geodatabases from a "soon to be" retired server over to a new server?

Our old server is running ArcGIS for Server 10.4.1 and our new server is running ArcGIS Server 10.9.1 with Microsoft SQL Server 2019.  Both ArcGIS Web Adaptor and ArcGIS Data Store are also installed of the same version (10.9.1), we do not employ Portal for ArcGIS, and ArcGIS Server Manager is up and running.

I have no practical experience with this type of scenario and would appreciate any and all advice and assistance.

If it's possible, ideally, we would like to keep the old server running as long as possible in order to foster a smooth transition to the new environment.

Thank you.

Jeff

[MarceloMarques]

There are many ways to migrate and upgrade the ArcSDE Enterprise Geodatabase.

1. take a full backup of the SQL Server database and restore on the new server.

- change the database compatibility level to SQL Server 2019

- upgrade the ArcSDE Geodatabase Repository with ArcCatalog 10.8.2 or ArcGIS Pro 2.9.x

- take a full backup of the new geodatabase

2. create a new enterprise geodatabase on the new server and copy/paste the data from the old geodatabase to the new geodatabase using ArcCatalog 10.8.2 or ArcGIS Pro 2.9.x / 3.0.x

- take a full backup of the new geodatabase

An experienced SQL Server Database Administrator + Geodatabase Administrator will be able to assist you with the migration.

[JD1016]

Thank you responding to my posting, Marcelo.

Can you provide links that feature explicit directions on how to perform both the scenarios you described above?

Jeff

[MarceloMarques · Accepted solution]

Methods to move a geodatabase in SQL Server—ArcGIS Pro | Documentation

Upgrade an enterprise geodatabase in SQL Server—ArcGIS Pro | Documentation

Client and geodatabase compatibility—ArcGIS Pro | Documentation

[JD1016]

Thank you, Marcelo!

[BillMyers]

Take a SQL backup from the old server and restore it on the new server. 

Note: The geodatabase name needs to be the same on the new server or it will not be recognized by the Esri software.