Dear forum members, I have simple but big problem regarding schema case in sql server enterprise gdb. If I create any table or feature class in sql server through ArcGIS then the schema name creates as uppercase letter by default and the table name is as it is. But in sql server table list (directly in sql server) I find all the schema name as lowercase (for example: dbo.TABLEX) but the table name in opposit case. If I again search through arcgis database connection then I see all the tables and feature class schema is uppercase ( for excample: DBO.tablex). This makes a big issue when I connect my db into fme and make some download data task.
My question is: is there any solution thus I can create the schema in lowercase from arcgis?
With kind Regards
Muqit Zoarder
Too bad you didn't get a reply. This is my problem also in 2023.
This is the same issue we are facing. This is the only post that I can find that mentions this issue. This is occurring when copying data to a v10.9.1 Enterprise GeoDatabase.