What are the challenges you face when working across database platforms? Take the survey
Options

Similar objects shown in differences group

cblaze22cblaze22 Posts: 3
edited April 11, 2012 12:26PM in SQL Compare Previous Versions
I am doing a compare and there are objects being shown in the differences group, but the compare view shows no differences. Am I missing something?

Comments

  • Options
    Just to clarify, are you saying that you highlight the object it found as being different, and the differences pane at the bottom shows nothing highlighted?

    If so, I've seen this kind of thing occur before where the only difference is in something like the carriage return type in the extended properties text (i.e. the DB has a CR, the other db (or script file if comparing to scripts) has a CRLF. Because these characters are invisible, nothing gets highlighted.

    You can narrow down what the difference is by ticking some of the ignore options- for instance ticking the option to ignore Extended Properties will then treat the objects as identical (assuming the only diff is in those)
    Systems Software Engineer

    Redgate Software

  • Options
    You are correct. I have all options checked as ignored in the settings but there is no setting called ignore Extended Properties.
  • Options
    Should be:

    image.jpg
    Systems Software Engineer

    Redgate Software

Sign In or Register to comment.