If the "Format before comparison" in your screeenshot is checked, then (assuming the only diffs are formatting), no diffs would be found and the schema compare would not identify the procedure as "different".
But if that option were unchecked, and "format source before comparison" in the file viewer is checked (below), then the schema compare would identify the difference, but the side-by-side viewer would not.
I think you need to uncheck option shown below. That won't unformat the currently displayed pair of procedures, but the next time the window opens. it won't format them and will show the differences.
I did a clean installation of Toad, did not copy user settings from previous installation and unchecked both “Format source before comparing” and “Ignore Case when Comparing Text” in the Merge Options menu.
It still gives me the same output when comparing and when I show the difference details the popup “No more diffences found” shows.
When I then copy over the output script and play it in the other dabase, and do another compare there is no more difference… Which is very strange, because that means there was actually a difference in the first place…
I’m sure it must be some kind of formatting option that gives us this result.
Copying the procedure to notepad results in no difference.
I’ve tried with a 3rd party product and there I could see the only difference in the two procedures is the word “procedure” in the “create or replace piece”. The first one is “procedure” and the second one is “PROCEDURE”. So Toad does not see this difference with current configuration settings. Still no idea what to change.
I’ve installed the latest update of Toad 12.12 and did another test in comparing the procedure.
It still shows the same procedure in the difference list, and when trying to compare the message “No more differences” does not show anymore. So it does still recognize their is a difference.
But it does not show what’s different… It’s just the same on both sides…
In Oracle SQL Developer the procedures show like this
We must be doing something different, because I cannot reproduce this. I want to fix this but I am not sure what I need to fix. Would you mind writing up some steps so that I can follow exactly what you are doing and reproduce the problem?
Toad compares everything beginning with the word “PROCEDURE” (since that is where the code starts in DBA_SOURCE), but when Toad builds the script for the side by side viewer, “PROCEDURE” is always in uppercase. The reason this happens is that sometimes we have to change the schema name in the script, so we just remove everything before the procedure name and then put it back in as appropriate.
I’ll make a change to preserve the original case of that word.
just installed the beta and at first it does not show any difference. It does say their are formatting differences it wants to show. After clicking yes, the difference in “lower case/upper case” does show. This way we are finally able to see the difference. Playing the script does also correct the difference, where it did not in the previous build.
Many thanks for this change/update !
With this update the comparing “columns” and “column comments” options has also been a huge improvement. We do notice that when comparing the column options the line “enable row movement” does no longer show as a difference. Any changes made on that?