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; } } }

Change SQL server for enterprise

Anonymous User

We are about to update from Enterprise 10.6.1 to 10.7.1. We are also updating our SQL to 2019. This new SQL database will be on a different server than it currently is. We will copy our SDE db to it. Is it possible during the Enterprise update to point it at the new SQL server? At what step does that occur?

I'm also trying to figure out if we are going to have to re-publish all of our services?

Thanks

Najděte více příspěvků označených jako

Accepted answers

All comments

George_Thompson

I would think it "should" work but it has not be "certified" against it as SQL 2019 came out after 10.7.1 did. I think that your thought of point 10.6.1 to SQL 2019 first may be the easiest route.

Anonymous User

I'm having trouble finding out if Enterprise 10.6.1 will work with SQL 2019.

I think the best route to go would be to point Enterprise 10.6.1 to the new server with SQL 2019, and then update 10.6.1 to 10.7.1

Otherwise, I'm in a bit of a catch 22.

Anonymous User

Oh, right. 2012 does not support 10.7.1.

Thanks for the links.

George_Thompson

If you do it after (or before) the upgrade it will allow you to validate the upgrade before making more "system wide" changes.

Just make sure that the "old" SQL Server version that is being used is supported on 10.7.1. Otherwise you may have weird behavior after the upgrade and before pointing to the new SQL Server. Thinking more about if you are currently using SQL 2012.

https://desktop.arcgis.com/en/system-requirements/10.7/database-requirements-sqlserver.htm

Here is some doc for updating the MXD's: Updating and fixing data sources with arcpy.mapping—Help | ArcGIS for Desktop

Anonymous User

Wait OK, the SQL server info is changed once the upgrade is complete. Thanks

Anonymous User

Thanks George.

We are trying to do this in baby steps as much as possible. So both sql databases will be up at same time, but Enterprise only pointed at one.

Is it possible to change the sde database/server at anytime, or should it be done during an Enterprise update?

George_Thompson

I believe that you will have to update all the SQL Server information once the upgrade is completed and the new SQL Server is available.

Be sure not to change the DB name during the restore. After it is restored, make sure to sync the logins (if using DB authentication) to the new SQL Server instance.

https://desktop.arcgis.com/en/arcmap/latest/manage-data/gdbs-in-sql-server/move-geodatabase-sqlserver.htm

Připojte se k diskusi

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

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