Skip to Content
author's profile photo Former Member
Former Member

Case sensitive Datastore in Dataservices 3.2

Hi,

I create Sql Server 2008 Datastores. Server locale and code page is in Turkish. "I" and "i" are different letters in Turkish, so i've to create this datastore as case-sensitive.

There is no case-sensitive property in datastore edit form. So i create it with default properties, than export it to an ATL file and change the case-sensitive attributes to yes from no and reimport it.

But everytime when i change the configuration of the datastore, case-sensitive attribute changes to no again. I've to rechange and the reimport the atl file again.

And sometimes, the case sensitive attribute does not include in the ATL file and have to manually add the attribute to the ATL file.

It is a pain to change the configuration between development, test and production datastores.

Is there an easier way to work with case-sensitive datastores ? Any global parameter for a repository, or any other recommendations ?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jun 28, 2012 at 06:59 PM

    I do not think DI can handle the case sensitivity names. But what you can do is create an alias using advanced option of the datastore and create an alias as the previous one in the repo.

    Arun

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thank you Arun,

      I test "alias" but it doesn't solve my problem.

      I found a solution. I create System Configurations. I do not need to change the configuration on datastores anymore. I just select the system configuration when executing the job. So the datastores case-senstive options are not broken.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.