Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

i need to change the property (Casesnsitve = on To Casesnsitve = oFF ) for a Databse created on SQl Anywhere 9

share|improve this question

You can't change the case sensitivity of an existing database. You will have to create a new database (the easiest way is to use the dbinit utility, but don't use the -c switch), and then use the dbunload utility to unload and reload the data into the new database.

share|improve this answer
Thank you very much for your kindly , i neet to add that my case is : i'am using that database with replication .i have 7 branch each one has a srerver which contain one remote user(database) of that databse ' ************** so i need to verify that i'am in the right way or not : i must Creat new dadabase for each remot user or Creat a new database for the main one then extract a new databse for each remot user ? – ahmed Feb 3 '10 at 11:56

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.