nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Find more posts tagged with

Enterprise geodatabase

Databases

Geodatabase Administration

Accepted answers

MMBR

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

All comments

MMBR

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

MMBR

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.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.