Case Sensitivity

EliBertEliBert Posts: 16
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!

Comments

  • 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.
    Software Developer
    Redgate Software
Sign In or Register to comment.