topic Re: Enterprise Geodatabase in Azure SQL database in Geodatabase Questions

Enterprise Geodatabase in Azure SQL database

JackChen2 — Sat, 02 Nov 2019 18:36:47 GMT

A sde-schema enterprise geodatabase was created in Azure SQL database. Attachment documents what I did.

Re: Enterprise Geodatabase in Azure SQL database

chakreshsahu — Wed, 19 Feb 2020 09:42:20 GMT

Hi Jack,

It was really helpful. I have created detailed document by using your help.

https://community.esri.com/message/909814-re-error-create-geo-database-create-database-statement-not-allowed-within-multi-statement-transaction?commentID=909814#comment-909814

Re: Enterprise Geodatabase in Azure SQL database

JackChen2 — Sun, 23 Feb 2020 17:19:18 GMT

Hey Sahu,

I am glad I did not waste my time on creating that PDF document. Thanks.

Sent from my iPhone

Re: Enterprise Geodatabase in Azure SQL database

Alex_Reid — Mon, 02 Mar 2020 16:25:31 GMT

Holy cow this is exactly what I have been looking for for the last week. I haven't had a chance to try it yet but thank you! Does this let you analyze/compress/analyze as well?

Re: Enterprise Geodatabase in Azure SQL database

KristineBarry — Thu, 23 Jun 2022 15:21:51 GMT

You did not waste your time, I'm looking at it too. Hopefully, not too much has changed in 2 years.

Re: Enterprise Geodatabase in Azure SQL database

CZhang — Wed, 03 Jul 2024 01:14:20 GMT

We go with dbo-schema EGDB with MS Entra Authentication only, created new AD login using in SQL, set user default schema to GISADMIN but the table created in ArcGIS Pro still default to dbo.tablename, not GISADMIN.TABLENAME. Is there guide like above for DBO-schema?