Database connections in arcgispro-py3

JohnBroecher

Since Pro stores database connections in a project, how do we connect to a database from within a standalone python script? 

For example below is how I would have previously connected in ArcGIS 10.5

import arcpy

GDB_directory = r"C:\Python Testing"

targetEntGDB = r"Database Connections/espr1sql14.sde/"

extractedGDB ="600150be54a84779a461d4fc37247f91.gdb"

extractedGDB = GDB_directory + "\" +extractedGDB

arcpy.Copy_management(extractedGDB, targetEntGDB)

JoshuaBixby

In ArcGIS Desktop/ArcMap, "Database Connections" is an application alias for the ArcCatalog folder in a users roaming application data directory.  I say it is an application alias because only the application and its tools are aware of it.  Although ArcGIS Pro still has roaming application data directories for users, database connection files are not stored their unless they have been marked as "Favorites," and even then it is a copy at a point in time of the original file.

Although "Database Connections" worked in ArcMap, I would argue the best practice is to give a fully-qualified path to the database connection file and not rely on a user-specific, application-level alias.  If you are using fully-qualified paths, the tools will work the same between ArcMap and ArcGIS Pro.

If you want to access a database connection file that is part of a project, the database connection files are stored in the project's "home folder" which can be accessed via the homeFolder property of an ArcPy Mapping project:

<SPAN class="keyword token">import</SPAN> arcpy
<SPAN class="keyword token">import</SPAN> os

aprx_file <SPAN class="operator token">=</SPAN> <SPAN class="comment token"># path to aprx file</SPAN>
GDB_directory <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"C:\Python Testing"</SPAN>

aprx <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>mp<SPAN class="punctuation token">.</SPAN>ArcGISProject<SPAN class="punctuation token">(</SPAN>aprx_file<SPAN class="punctuation token">)</SPAN>
targetEntGDB <SPAN class="operator token">=</SPAN> os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>aprx<SPAN class="punctuation token">.</SPAN>homeFolder<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"espr1sql14.sde"</SPAN><SPAN class="punctuation token">)</SPAN>
extractedGDB <SPAN class="operator token">=</SPAN><SPAN class="string token">"600150be54a84779a461d4fc37247f91.gdb"</SPAN>
extractedGDB <SPAN class="operator token">=</SPAN> os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>GDB_directory<SPAN class="punctuation token">,</SPAN> extractedGDB<SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>Copy_management<SPAN class="punctuation token">(</SPAN>extractedGDB<SPAN class="punctuation token">,</SPAN> targetEntGDB<SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Note:  You really want to use os.path.join to build paths.