How do I compare databases with a binary sort order?
If you have databases with binary sort order then you should use the Treat items as case sensitive option. Note that this is not a setting you should change frequently. In particular, if you are comparing an offline database snapshot (.snp) file with another snapshot or live database, and the case sensitive option has changed, then SQL Compare may give unexpected errors.
Related Questions
- Can I compare databases without taking indexes and constraints into account so that SQL Examiner does not offer me to synchronize tables with the same set of columns as different after the comparison?
- Is this the widest binary of any sort we know in the Kuiper belt of just the widest among equal mass objects?
- How does DFPAL performance compare to say binary floating point and compiler native decimal floating point?