Changing Domain Owner

[TimHayes]

I am using ArcGIS 10.2.1 with SQL Server 2008 R2, the dbo schema.

I have around 40 Domains. The Domain Owner for 10 of these are "Mister X"; The Domain Owner for the remaining 30 of these are "Mister Y". Mister Y has the dbo role and dbo is shown under the Domain Owner for this person. The Domain Owner under "Mister X" is listed as his user name.

How do I change the Domain Owner to all dbo?

I know I could have Mister X delete his 10 Domains and then I, as the dbo, can re-create them one by one so they would be owned by me. But, that is a lot of work, just wondering if there is an easier way.

[AsrujitSengupta · Accepted solution]

Tim,

Unfortunately there is no direct tool to change Domain Owner for a geodatabase.

You can try below workflow:
1. Export existing domains owned by 'X' to a table using 'Domain to Table' tool
2. Remove the existing domains owned by 'X' from the fields in the data
3. Delete the domains owned by 'X' connected as user 'X'
4. Import the domains from the tables created in step 1 using 'Table to Domain' tool connected as the "DBO" user
5. Assign newly created domains in step-4 to fields from which they were removed in step 2

This works successfully for me. However do take a backup of the geodatabase before trying this at your end OR test it on a test geodatabase and then implement it.

Domain To Table (Data Management):
http://resources.arcgis.com/en/help/main/10.2/index.html#//001700000022000000

Table To Domain (Data Management):
http://resources.arcgis.com/en/help/main/10.2/index.html#//001700000025000000

Hope this helps!