Comparing views problem

Brian Donahue

Hi Trev,

Just out of curiousity, do you have the 'Ignore white space' option on?

Thanks,

Brian Donahue
Red Gate Technical Support

"Trev@Work" <bouncer@localhost> wrote in message
news:dTxvqUYuDHA.1668@server53...
> I have two databases (well more than 2 but I'll keep it simple) and a lot
of
> the views show up as different, the problem is they may be the same but
for
> formatting of text, e.g.
>
> Create view view1
> as
> select blah1, blah2, blah3, blah4, blah5
> from table
>
> as opposed to
>
> Create view view1
> as
> select blah1,
> blah2,
> blah3,
> blah4,
> blah5
> from table
>
>
>

Brian Donahue

Hi Trev,

Nope, just Ignore White Space. That should encompass CRLF as well.
By the way, we're up to SQL Compare version 3.1. You should try doing a
check for updates from inside the software.

Thanks,

Brian Donahue
Red Gate Technical Support

"Trev@Work" <bouncer@localhost> wrote in message
news:SSJbdmouDHA.1248@server53...
> "Brian Donahue (Red Gate)" <brian.donahue@red-gate.com> wrote in message
> news:A$DcfibuDHA.1244@server53...
> > Hi Trev,
> >
> > Just out of curiousity, do you have the 'Ignore white space' option
> on?
>
> Yes, is there an option to ignore CRLF?
> (v 3.0.0.130)
>
>