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

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?


Brian Donahue
Red Gate Technical Support

"Linwood Ferguson" <Ferguson@chaslevy.com> wrote in message
> 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,
> 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
> names. For example, here are two lines flagged as green:
> CONSTRAINT [PK__BookCat__00200768] PRIMARY KEY CLUSTERED ([BookCatCd])
> I read the FAQ saying that it will still show the differences, BUT, as
> 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
> and manually look to see what's different. Admittedly easier than by
> but not much.
> What am I missing?
> Linwood Ferguson
> Ferguson@chaslevy.com
This discussion has been closed.