Case Sensitivity

EliBert

Dear Sir,

We have a case sensitivity problem when uploading our databases with data compare with command line.

I already tried different options (parameters). It probably depends on the settting of the database server collation.
Now i am looking for an alternative solution. My problem is situated in a rather small table so i'm wandering if i can't upload it completely. Kinda like upload to an empty table, so not compairing but replacing. Is this possible?

Thanks!

Michelle T

The easiest way I can think of doing this is by truncating the target table by some other means before using Data Compare on it (batch file that runs osql and then the data compare command line?). It's not something we provide any particular feature for doing.