topic Re: How to create a case-insensitive Enterprise geodatabase in SQL server?? in Geodatabase Questions

How to create a case-insensitive Enterprise geodatabase in SQL server??

Muqit_Zoarder — Tue, 12 Jun 2018 10:56:35 GMT

Dear forum, plesae concerned persons reply me. Some months back I had make the same discussions on why the schema name and table name looks different in " case " in both arccatalog and in sql server table list (directly). For example: if I have one table created form arccatalog showing its name as DBO.Soil_Sample_a then the same table name is showing in sql server as dbo.SOIL_SAMPLE_A ?? But is there a solution for this thus i can avoid this type of case insensitivity?

With kind regards

Muqit Zoarder

Re: How to create a case-insensitive Enterprise geodatabase in SQL server??

George_Thompson — Tue, 12 Jun 2018 13:04:28 GMT

Not sure that this helps but found this in the documentation:

Before you create a geodatabase, SQL Server must be installed and the instance configured. How you configure the instance depends on the specific needs of your organization. However, note that the SQL Server instance must use a case-insensitive collation.

Under "Install and Configure SQL Server": Create an enterprise geodatabase in SQL Server—Help | ArcGIS Desktop

Re: How to create a case-insensitive Enterprise geodatabase in SQL server??

Muqit_Zoarder — Tue, 12 Jun 2018 13:31:20 GMT

Dear George, before creating enterprise gdb in sql server obviously i have installed sql server and instance has been configured as case insensitive (Latin1_General_CI_AS). Even though I am getting this trouble. It might be a common problem of enterprise gdb.