How can we help you today? How can we help you today?

Comparing views problem

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
0

Comments

1 comment

Sort by
  • 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)
    >
    >
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.