topic Re: Change SQL server for enterprise in ArcGIS Enterprise Questions

Change SQL server for enterprise

Anonymous User — Mon, 06 Apr 2020 12:25:22 GMT

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

Re: Change SQL server for enterprise

George_Thompson — Mon, 06 Apr 2020 12:47:29 GMT

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

Re: Change SQL server for enterprise

Anonymous User — Mon, 06 Apr 2020 14:08:34 GMT

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?

Re: Change SQL server for enterprise

Anonymous User — Mon, 06 Apr 2020 14:10:57 GMT

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

Re: Change SQL server for enterprise

George_Thompson — Mon, 06 Apr 2020 14:21:09 GMT

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

Re: Change SQL server for enterprise

Anonymous User — Mon, 06 Apr 2020 14:28:57 GMT

Oh, right. 2012 does not support 10.7.1.

Thanks for the links.

Re: Change SQL server for enterprise

Anonymous User — Mon, 06 Apr 2020 15:01:22 GMT

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.

Re: Change SQL server for enterprise

George_Thompson — Mon, 06 Apr 2020 15:09:32 GMT

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.