Options
Different object showing as identical
Brian Donahue
Posts: 6,590 Bronze 1
Hi,
We know that there is a discrepancy between the comparison results and
the SQL window due to the fact that they use two completely different
methods to compare the object's SQL. Because SQL Compare uses a proprietary
internal formatting to represent the SQL of a database object, and the SQL
Windows use an entirely different method, they often don't match up despite
lots of hard work on our part to get the two comparison methods as close as
possible.
Kind Regards,
Brian Donahue
Red Gate Technical Support
"Kristian Giil" <kristian@adp.no> wrote in message
news:mFGPLQIyDHA.1244@server53...
> I have discovered a consistent bug: some stored procedures show status
equal
> in main window, but the "creation sql" show completely different
definitions
> of the procedure.
>
> I have tried different settings in options, with no help. I have checked
> this error between several databases, so I know this error is consistent.
>
> (see attached image)
>
>
>
We know that there is a discrepancy between the comparison results and
the SQL window due to the fact that they use two completely different
methods to compare the object's SQL. Because SQL Compare uses a proprietary
internal formatting to represent the SQL of a database object, and the SQL
Windows use an entirely different method, they often don't match up despite
lots of hard work on our part to get the two comparison methods as close as
possible.
Kind Regards,
Brian Donahue
Red Gate Technical Support
"Kristian Giil" <kristian@adp.no> wrote in message
news:mFGPLQIyDHA.1244@server53...
> I have discovered a consistent bug: some stored procedures show status
equal
> in main window, but the "creation sql" show completely different
definitions
> of the procedure.
>
> I have tried different settings in options, with no help. I have checked
> this error between several databases, so I know this error is consistent.
>
> (see attached image)
>
>
>
This discussion has been closed.
