AnsweredAssumed Answered

Changing data owners during SDE geodatabase sync

Question asked by naalexandrou on Sep 16, 2016
Latest reply on Sep 16, 2016 by George_Thompson-esristaff

I recently was in discussion with the GIS Specialist at a different county organization. They have two geodatabases that have a 1 way sync from the EDITdb (for departments to perform maintenance and edits) to ReadOnly db (for use with publishing web services)

He said that when the data is in the EDITdb, it is all owned by the database admin account named GIS.

When they run their nightly sync tool from the EDITdb to the READONLYdb, they are changing the data owner. In the READONLYdb they have set up a handful of different accounts in SQL that have data creator privileges for different departments (DOT, Environmental, ParksAndRec, etc).

When the sync tool runs, the data goes from being owned by admin GIS, to being owned by the various departments in the READONLY. So data syncs from being EDIT.GIS.Lakes to READONLY.Environmental.Lakes. Or EDIT.GIS.Parcels to READONLY.Planning.Parcels ... etc

I'm curious how this was done as it makes for a very nice organizational pattern in the READONLYdb with everything being separated by data owner (SDE.DOT or SDE.ParksandRec or SDE.Planning, etc).

Anybody know how data owners can change and the sync tool can still run without conflicts? I've only run syncs where the data owners remained the same. I don't even know where to begin with changing owners.

Any help is appreciated!