Hello,
I came across this post that hasn't been updated for awhile: https://community.esri.com/t5/arcgis-pro-questions/manage-sql-server-express/td-p/403017/page/2
Is it still not possible to create a database server connection to manage Sql Express databases from directly in Pro? We are attempting to migrate to Pro for everything and are concerned that this still doesn't appear to be an option in Pro.
Thanks.
Turns out, you CAN create a SQL Express database (for now anyway)! Run the Create Enterprise GeoDatabase tool from Pro, and manually enter the instance name (or copy/paste from SSMS). No need to connect directly to the database server like we did in ArcMap. I still used my old ArcMap key codes file. It worked!
Thanks for the info, RobertMy agency has used database replication to collect/aggrigate data from many sources for use in 9-1-1 call routing and dispatch mapping. Most of the jurisdictions we get this data from do not have access to a full server. Several of them have had to get new computers just to be able to run ArcGIS Pro, so we are doing fresh installs on those computers. It is detrimental to the "must start using Pro" movement for them to see us immideately install ArcCatalog to get them set up.
Hi @KaseyCox - with regards to the "Add Database Server" workflow in ArcGIS Pro. There was ENH-000131059 - Add an ability to create Desktop and Workgroup geodatabase in ArcGIS Pro. There are no plans to support creating Desktop and Workgroup geodatabases and implementing a 'Database Servers' node in ArcGIS Pro.The ArcGIS Enterprise Workgroup license is being phased out with ArcGIS Desktop, with ArcGIS Enterprise 11.1 being the last version to support the Workgroup license. Workgroup geodatabases will need to be migrated to enterprise geodatabases as part of migrating an ArcGIS Enterprise Workgroup license to an Enterprise license.FAQ: Is It Possible to Create a Workgroup Geodatabase in ArcGIS Pro?Not an ideal answer I know but this is what I found out. Let me know if you have any additional questions and I'd be happy to assist.
Same here! Its hard to get users on-board witht he switch when we still have to jump back in to ArcCatalog for some things!!!!
Hi @Robert_LeClair and @Anonymous User I checked with colleagues and was pointed to the following guidance.
Please note that the ArcGIS Enterprise Workgroup licensing is being phased out with ArcGIS Desktop (ArcMap / ArcCatalog). The ArcGIS Enterprise 11.1 release is the last version to support the ArcGIS Enterprise Workgroup license. If you are using Workgroup geodatabases, you should evaluate migrating to one of the supported database types beyond SQL Server Express.
Related documentation on applying a full ArcGIS Enterprise license to ArcGIS Enterprise Workgroup:
https://support.esri.com/en-us/knowledge-base/how-to-apply-a-full-arcgis-enterprise-license-to-arcgis-000028255
Desktop geodatabases can only be created from ArcGIS Desktop (ArcMap / ArcCatalog). This geodatabase type will be phased out when ArcGIS Desktop (ArcMap / ArcCatalog) is retired in March 2026. For users of desktop geodatabases, we recommend evaluating mobile geodatabases for enhanced capabilities.
No, we unfortunately never found a solution to this. We are not yet sure what we will do for our next major upgrade as it appears this option has been quietly removed from 11...
So it seems that workgroup geodatabases can be used in ArcGIS Server and ArcMap according to this help document but cannot be created in ArcGIS Pro.
@KoryKramer - can you provide additional information to AndreaB?
Infuriating - I assume that Sql Express databases/ Workgroup is going away. Esri, official notification would be nice.
@Anonymous User - certainly - here's the link - FAQ: Is It Possible to Create a Workgroup Geodatabase in ArcGIS Pro? (esri.com)
@Robert_LeClair 404 error on your second link - can you relink please? Thank you.
@KG_427 did you find an existing idea? @KoryKramer ?
That I don't know Kim as I don't work on the ArcGIS Pro Development Teams rather I work for Training Services. One option is to review existing ArcGIS Ideas to see if there is an idea to support this. If there is not, then you can add a new idea.
Thanks for those, but it doesn't look like to me that it gives you the option to manage users. Is there a plan to make this an option in Pro?
Kind of...two great resources here:
Types of geodatabases—ArcGIS Pro | Documentation
FAQ: Is it possible to create a workgroup geodatabase in ArcGIS Pro? (esri.com)
From the information in the Current Help documentation, it appears only ArcMap can create Workgroup geodatabases. You should be able to create a geodatabase connection (.sde file) to consume the data stored in workgroup with a user account that has permissions (using ArcGIS Desktop or ArcGIS Pro), then use that file in ArcGIS Pro to add the data to your project. More information on that here.
Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
