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.
| Marcelo Marques | Principal Product Engineer | Esri |
| Cloud & Database Administrator | OCP - Oracle Certified Professional |
I work with Enterprise Geodatabases since 1997.
“ I do not fear computers. I fear the lack of them." Isaac Isimov