ArcGIS Pro and local SQL Express DB

4515
12
09-18-2019 11:20 PM
StuartMoore
Occasional Contributor III

Hi,

i've searched everywhere (well everywhere i can think off) and i am struggling, back when i had ArcMap 10 you could create an local SQL express DB but i can't seem to find the same in ArcGIS Pro.

i've installed SQL Server Dev edition and can connect Pro to it, i can create a feautre class in the SQL DB, i can copy a feature class to the SQL DB but when add it into pro to update / create new features its added as a query layer and i cant edit it

i am guessing i've done it wrong some how....

Stu

0 Kudos
12 Replies
George_Thompson
Esri Frequent Contributor

The old version of the SQL Express geodatabase was referred to a personal or workgroup geodatabase. See more details here: ArcSDE for SQL Server Express limitations? 

What you are experiencing is expected with SQL Server Dev (or any "full" version of SQL Server). You have to create/enable an enterprise geodatabase to have the edit functionality from ArcGIS Pro; Databases and ArcGIS—Help | ArcGIS Desktop 

Here are some other GeoNet post related to ArcGIS Pro and SQL Server Express:

Manage Sql Server Express 

Using ArcPro can you create a geodatabase in SQL Express Server? 

Let me know if you have any other questions.

--- George T.
ZacharyHart
Occasional Contributor III

All I'm seeing from multiple threads is that there is absolutely no way to create a GDB in SQL Express with Pro.

George_Thompson
Esri Frequent Contributor

As far as I know that is still correct. ArcGIS Pro only supports file and enterprise geodatabases.

Client and geodatabase compatibility—ArcGIS Pro | Documentation

  • ArcGIS Pro (supports connecting to file and enterprise geodatabases)
  • ArcGIS Server services (support connecting to file, workgroup, and enterprise geodatabases)
--- George T.
0 Kudos
ZacharyHart
Occasional Contributor III

That's not quite correct and I'm sure this is a source of much confusion. You can still create DBs in SQL express (desktop or workgroup edition DB server) wirh ArcMap and then work with them just fine in Pro.

You cannot CREATE those DBs in Pro, however. 

I don't understand how Pro will be a full replacement for desktop with major functionality like this still missing. 

I don't understand how after years of users asking the same/similar question that Esri cannot clarify the roadmap here.

Should we start planning that 2way replica environments will no longer be possible without a full ArcGIS Server Standard license for both participating DB instances?? 

George_Thompson
Esri Frequent Contributor

You are correct on the creation of SQL Express DB's using ArcMap. I was also able to find this FAQ: Is it possible to create a workgroup geodatabase in ArcGIS Pro? 

I would highly recommend logging an enhancement with technical support, if not already done.

--- George T.
0 Kudos
ZacharyHart
Occasional Contributor III

It seems to be discussed in this idea submission here.

However, this is a very broad topic and a huge thread of comments...I have no idea of knowing what enhancements are on track towards implementation.

0 Kudos
George_Thompson
Esri Frequent Contributor

I did provide some feedback internally to the Geodatabase team based on this thread. I think that they are working on some documentation for the next release. I do not have any other information outside of that.

My opinion - I can understand the use cases for SQL Server express DB's but find that the limitations they impose (from the MS side more than Esri) creates issues overall with performance and size limits. 

Nana Dei

--- George T.
0 Kudos
ZacharyHart
Occasional Contributor III

Thank-you.

Performance issues aside, Desktop Database Servers (via SQL Express) are instrumental to distributed data workflows. It's important to remember that there are still places in the world where connectivity is sparse and bandwidth is meager such that direct DB connections (via WAN/VPN) or FS editing are simply not feasible. However, the replicated data model is time-proven and can also be enhanced with version management. Not being able to work with database server instances (using SQL Express) fundamentally cuts-out the 2-way replica option without having an ArcGIS Server license, and given what we are seeing here it's likely/possible that ArcGIS Workgroup is on the chopping block as well!

BrunoBlanco
New Contributor II

100% agree. In our case,  we have several rural users who still use SQL Server Express databases extensively for their daily mission-critical work (9-1-1 addressing). They have not fully transitioned to Pro yet and will not transition until it's absolutely necessary. Honestly? Things like this are a huge part of the reason why.