Latest Contributions by George_Thompson

Oh, so you were opening the Pro projects from a cloud drive.... I would anticipate that would take a while to open and populate the layers. ... View more

I would anticipate less than optional performance when connecting over VPN. The network and VPN client (scanning / encrypting / decrypting / other VPN things) is going to more than likely be the limiting factor in this. The ArcGIS clients need robust communication between the clients (Database / Pro / Enterprise). I know that there may be some people to crack open the special sauce on the VPN / Pro client performance; but in my experience, it is usually not as good as being in the same cloud / datacenter / office. We normally recommend that the Pro client is in the same datacenter / cloud region as the geodatabase; https://enterprise.arcgis.com/en/system-requirements/latest/windows/databases-in-the-cloud.htm This helps to cut down on latency / performance issues as you are experiencing. I would recommend testing having a Pro client in your Azure cloud (https://pro.arcgis.com/en/pro-app/latest/get-started/pro-on-azure-cloud.htm) and do some testing to see if the performance is better. Another option, depending on the use cases and functionality needed, would be to publish the feature classes as feature services and edit via REST services. This would improve the performance when editing on VPN connecting to your ArcGIS Enterprise deployment. Hope this helps point you in the correct direction. Let us know if you have any other questions. ... View more

What is the data source that you are updating from? I wonder is the Input has some weird schema attribute in it. ... View more

What are the errors being received? What is the RDBMS version / Enterprise Geodatabase version? How are you appending this data: GP tool, Python, etc.? I think that we will need a few more details to help with this. ... View more

The simplest way I would recommend to accomplish this the following: Recommend removing db_owner role from SDE, except for upgrade process May want to grant VIEW DEFINITION to SDE if not already done https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-sql-server/privileges-sqlserver.htm  Create a Database user (Not a domain account - see comment from @MarceloMarques ) with the GP tool: https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/create-database-user.htm  - you must use a connection that SYSADMIN server role This can be done for multiple data owners as needed For the users that will view / edit the data, I recommend using Active Directory (AD) groups so that you do not have to manage user names / passwords for each person. You just add the group in ArcGIS Pro with the correct permissions (View or Edit) If they leave your company their account is turned off and you do not have to do anything. You just need to make sure that you secure the PW to the SDE and Data Owner accounts. If a person leaves the company, it may be best practice to update the PW for those users as needed. This should prevent issues with data ownership being a "free for all" in your organization. All the "management" of the tables will be done by the data owner, to simplify administration of these tables. There may be some other ways, but this has been successful in the past. Hope this helps! ... View more

@RusselBell have you seen the updated documentation on this: https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/overview/arcgis-field-data-types.htm#GUID-3C98DA8B-8D97-4E9F-AA34-F69C737A9871     and the new GP tool: https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/migrateobjectidto64bit.htm I would review the information in the documentation before running the tool.         ... View more

You can download the ArcGIS Coordinate Systems Data file from My Esri under the ArcGIS Pro 3.2 downloads page:       ... View more

I am not sure of a specific recommendation. It may be best to contact Technical Support and work with an analyst on this issue. ... View more

There are pros / cons to both ways. I would say that file geodatabase (fGDB) is not a bad way for storing that data for archive. The bigger thing would be related to the data security, if this is being discussed for the archived data I would lean towards the Enterprise Geodatabase (EGDB). I can also say that many DBA's do not like to store data in the EGDB that is not being used, as it "cost" more to house it in the RDBMS and maintain. I will be interested to hear others thoughts......  ... View more

Are you using the same connection information UN / PW in Pro as QGIS? In my connections with PostgreSQL, I can see what the user has access to. If you have user with (superuser) then they can see many other items that some could not. ... View more

Here is another data point in terms of hardware for up-to 25 users: https://www.esri.com/content/dam/esrisites/en-us/media/pdf/hardware-partners/dell/dellvirtualizationappliance.pdf Not apples-to-apples, but gives some context. ... View more

We support PostgreSQL also and have had many clients move that direction. ... View more

Ok, my hunch may have been correct....... you need to update the version of SQL Server to at least SQL 2016 to be on a supported version of SQL Server (https://enterprise.arcgis.com/en/system-requirements/latest/windows/database-requirements-sqlserver.htm).  I would recommend something newer like 2019 or 2022 for the SQL version to get more mileage. I do not think that version of SQL Server has been supported since before Enterprise 10.9.1 / Pro 2.9 in terms of our clients and DBMS combinations. I would look at upgrading the geodatabase to a newer version: https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-sql-server/upgrade-geodatabase-sqlserver.htm I would also make sure that you verify any dependencies on the geodatabases to other GIS systems, like Enterprise. ... View more

Getting the version of the geodatabase and RDBMS would be most helpful for any potential troubleshooting. Have your admin query the SDE_version table and return the info for the geodatabase side. ... View more