topic Branch Versioning for DBO owned geodatabase in Geodatabase Questions

Branch Versioning for DBO owned geodatabase

VishApte — Wed, 30 Jan 2019 00:01:44 GMT

Hi,

I have an Enterprise Geodatabase in SQL Server 2016 and I am building Utility Network using ArcGIS Pro 2.2. My geodatabase is created as DBO owned schema and not as SDE owned schema. When I set geodatabase connection properties with versioning type set to Branch, it sets the version name as DEFAULT and owner as "SDE" and does not let me choose different owner. I do not have SDE log-in or SDE user in the SQL Server database. Will any functionality be affected if I start using branch versioning without SDE user in the database?

Cheers,

Vish

Re: Branch Versioning for DBO owned geodatabase

George_Thompson — Wed, 30 Jan 2019 14:19:14 GMT

Did you publish out the data as branch versioned to your Enterprise portal; Share branch versioned data—Geodatabases | ArcGIS Desktop

Re: Branch Versioning for DBO owned geodatabase

KrishnaRohitYejju1 — Fri, 01 Feb 2019 05:13:44 GMT

@Vish Apte, I think you won't be able to use DBO owned schema geodatabase to use Branch versioning. Also, you would not be able to publish the data. I would suggest to use a new SDE owned schema geodatabase.

Re: Branch Versioning for DBO owned geodatabase

VishApte — Fri, 01 Feb 2019 06:33:36 GMT

Hi George,

I have been able to publish a Utility Network to ArcGIS Enterprise as feature services using Branched Version, have been able to create new versions, perform edits, reconcile and post to DEFAULT etc. So all working so far with DBO owned schema. It seems that owner of the DEFAULT branch version is "hardcoded" as SDE, like a keyword without a need for this user/owner to exist in the database.

I just want to know if DBO owned EGDB is supported for Branch Versioning and something is not going to bite me later in the production system.

Cheers,

Vish

Re: Branch Versioning for DBO owned geodatabase

George_Thompson — Fri, 01 Feb 2019 13:33:40 GMT

I would reach out to Esri Technical support and create a case on this question. They may be the best to respond.

Re: Branch Versioning for DBO owned geodatabase

ConnorFriese — Tue, 26 Mar 2019 14:23:40 GMT

Vish Apte‌

It is by design to have the SDE user owner of the DEFAULT version when working with branch versioning.

However, this does not cause any problems if it is a DBO owned schema geodatabase.

I believe the reason to display "SDE" as the owner is for security reasons. If "DBO" was listed then this would inform people that SQL Server is being used and this could be a security issue. Also, DBO comes with security issues in general since any user with the "sysadmin" fixed server role can become DBO.

Overall, having a DBO owned schema geodatabase is supported with Branch Versioning.

Re: Branch Versioning for DBO owned geodatabase

VishApte — Tue, 26 Mar 2019 22:15:26 GMT

Thanks for confirming Connor Friese

Re: Branch Versioning for DBO owned geodatabase

MaliniRamalingam — Tue, 07 May 2019 17:25:44 GMT

As confirmed by others, DBO owned schema geodatabase is supported with Branch Versioning.

Understanding the Default branch version:

In a DBO schema geodatabase, the sde.Default version refers to the Default branch version and DBO.Default refers to the traditional Default version.

In Branch versioning, versions are created and managed differently from Traditional database versions. In traditional versioning, database users create and own versions whereas in branch versioning, versions are created within feature services (or Utility network service) and managed by a version management service. So these branch versions are owned by the portal user connected to ArcGIS Pro, at the time they were created. You can compare the Owner column in the SDE_Branches table and the SDE_Versions from SQL Server management studio to clarify the concept.

Since the Default version is created by the system when the geodatabase is created, the SDE keyword under the owner column in the system table Branches, is most likely meant to indicate this concept.

I hope this helps clarify your question.

Re: Branch Versioning for DBO owned geodatabase

BillFox — Tue, 07 May 2019 17:43:52 GMT

A shorter answer seems it is a mistake "BUG" and should not be listed as "sde"

Re: Branch Versioning for DBO owned geodatabase

MaliniRamalingam — Sat, 25 May 2019 05:02:40 GMT

It is understandable that Branch versioning is a fairly new concept and so the terms can be ambiguous at times. Each versioning type, Branch or Traditional, caters to particular workflows and deployment options. Branch versioning concepts are only applicable when working with feature services.

Please do reach out to ESRI Support Services and we would happy to help comprehend Branch versioning concepts especially in comparison to traditional versioning as well as working with branch versioned data.

Re: Branch Versioning for DBO owned geodatabase

SavageTrimble — Tue, 23 Mar 2021 22:18:46 GMT

DBO Schema support for branch versioning? Data store support for branch versioning?