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

Different object showing as identical

Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
edited December 22, 2003 10:57AM in SQL Compare Previous Versions

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

Kind Regards,

Brian Donahue
Red Gate Technical Support

"Kristian Giil" <kristian@adp.no> wrote in message
> I have discovered a consistent bug: some stored procedures show status
> in main window, but the "creation sql" show completely different
> 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.