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?
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.
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?
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.
Here is some doc for updating the MXD's: Updating and fixing data sources with arcpy.mapping—Help | ArcGIS for Desktop
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.
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.