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

Comparing views problem

Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
edited December 8, 2003 12:16PM in SQL Compare Previous Versions
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
>
>
>

Comments

  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    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)
    >
    >
This discussion has been closed.