https://community.esri.com/t5/geodatabase-questions/is-it-safe-to-work-with-my-enterprise-database/m-p/1273019#M8363 <P>When working with database tables in ArcGIS Pro the processing seems pretty slow. I believe the culprits are the cursors (search, update, insert) and I would like to walk away from using those.</P><P>So I was wondering if I can simply switch to SQL in e.g. SQL Server Management Studio, work there and return later to ArcGIS Pro, without destroying something. By 'destroying something' I mean stuff in the GDB_*, SDE_* and i* tables.</P><P>Is it possible to work with Enterprise SQL databases purely in SQL, and if so, are there limitations on what I cannot do?</P><P>Bests Thomas</P> Wed, 29 Mar 2023 13:18:25 GMT TomGeo 2023-03-29T13:18:25Z https://community.esri.com/t5/geodatabase-questions/is-it-safe-to-work-with-my-enterprise-database/m-p/1273019#M8363 <P>When working with database tables in ArcGIS Pro the processing seems pretty slow. I believe the culprits are the cursors (search, update, insert) and I would like to walk away from using those.</P><P>So I was wondering if I can simply switch to SQL in e.g. SQL Server Management Studio, work there and return later to ArcGIS Pro, without destroying something. By 'destroying something' I mean stuff in the GDB_*, SDE_* and i* tables.</P><P>Is it possible to work with Enterprise SQL databases purely in SQL, and if so, are there limitations on what I cannot do?</P><P>Bests Thomas</P> Wed, 29 Mar 2023 13:18:25 GMT https://community.esri.com/t5/geodatabase-questions/is-it-safe-to-work-with-my-enterprise-database/m-p/1273019#M8363 TomGeo 2023-03-29T13:18:25Z https://community.esri.com/t5/geodatabase-questions/is-it-safe-to-work-with-my-enterprise-database/m-p/1273048#M8364 <P>In general it is safe. There are some issues that can arrise with versioning, network datasets, utility network, etc.<BR /><BR />I would recommend reviewing these doc pages:&nbsp;<A href="https://pro.arcgis.com/en/pro-app/latest/arcpy/get-started/executing-sql-using-an-egdb-connection.htm" target="_blank">https://pro.arcgis.com/en/pro-app/latest/arcpy/get-started/executing-sql-using-an-egdb-connection.htm</A>&nbsp;&amp;&nbsp;<A href="https://desktop.arcgis.com/en/arcmap/latest/manage-data/using-sql-with-gdbs/sql-and-enterprise-geodatabases.htm" target="_blank">https://desktop.arcgis.com/en/arcmap/latest/manage-data/using-sql-with-gdbs/sql-and-enterprise-geodatabases.htm</A>&nbsp;for some more insight.</P><P>Again <FONT color="#FF0000"><U><STRONG>DO NOT</STRONG></U>&nbsp;&nbsp;</FONT>modify the repository tables via SQL, as you noted.</P> Wed, 29 Mar 2023 14:28:26 GMT https://community.esri.com/t5/geodatabase-questions/is-it-safe-to-work-with-my-enterprise-database/m-p/1273048#M8364 George_Thompson 2023-03-29T14:28:26Z