Select to view content in your preferred language

SQL RDBMS use with file geodatabases in ArcGIS Pro 3.x

2613
12
Jump to solution
05-06-2024 09:36 AM
Labels (3)
NiColahh
Occasional Contributor

Hello,

Can someone please tell me if PostgreSQL/PostGIS (or any SQL RDMS) can be used on file geodatabases (rather than on SDE databases) with ArcGIS Pro 3.x? I just started a new position and have an ArcGIS Professional Basic license, which doesn't include use of SDE. I'd like to work with my GIS data in a RDMS but have never tried with file geodatabases before.

Thanks,

Nicole

0 Kudos
12 Replies
VinceAngelo
Esri Esteemed Contributor

It was right there:


(i.e., generate SQL on the fly to execute in the database through a cursor)

I also wrote "much more difficult". If you haven't spent the past six months generating `psql` INSERT statements in a Python DA SearchCursor query, it's still "possible", just a heck of a lot of work. Way more work than dragging and dropping a FGDB feature class into a connection file with a Standard or Advanced seat license (against a properly prepared PG database with a lower-case schema that matches the login and has the correct permissions).

- V

NiColahh
Occasional Contributor

I gotcha--good to know. Thank you for the input. 

0 Kudos
VinceAngelo
Esri Esteemed Contributor

The answer that this quoted was probably a better candidate for "Solution" marking.

0 Kudos