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

Ignore Names still flags table as different? (SQLCompare 2.03)

Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
edited August 6, 2003 11:26AM in SQL Compare Previous Versions
Hi Linwood,

After giving this quite a bit of thought, I can't find anything that
would give a false difference, based on what you've written. Maybe it would
help if you sent an SQL script of the tables to support@red-gate.com so we
could have a look?

Thanks,

Brian Donahue
Red Gate Technical Support

"Linwood Ferguson" <Ferguson@chaslevy.com> wrote in message
news:pyM9zS7VDHA.1520@server53...
> I'm missing something.
>
> I have transactional replicated tables, which means there are triggers
> added. We also have a few primary keys where there was no name declared,
so
> those are random.
>
> I've set the Ignore options for spaces, tabs and names.
>
> The tables show as different, when I expand the only things shown are
these
> names. For example, here are two lines flagged as green:
>
> CONSTRAINT [PK__BookCat__00200768] PRIMARY KEY CLUSTERED ([BookCatCd])
> CONSTRAINT [PK__BookCat__350BFE4F] PRIMARY KEY CLUSTERED ([BookCatCd])
>
>
> I read the FAQ saying that it will still show the differences, BUT, as
best
> I can tell the only differences are in the names, and I do not want the
> table to show at all. If it shows it ends up making me open up EVERY
table
> and manually look to see what's different. Admittedly easier than by
hand,
> but not much.
>
> What am I missing?
>
> Linwood Ferguson
> Ferguson@chaslevy.com
>
>
>
This discussion has been closed.