Options

Two Column are the same

Rand626Rand626 Posts: 2
edited May 2, 2005 11:03AM in SQL Compare Previous Versions
I compared two databases on two different servers. In one of the table I noticed that it said that a column did not exist in DB2 but if you looked a little further down it was there in DB2. I tried to use the option to force column order but that did not work.

Is there a way to correctly have the columns line up on both views.

:roll:
Art Lorenzini
State of South Dakota
DBA Group
Aberdeen, Sd
· Share on Twitter

Comments

  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hi Art,

    I really hate pointing it out, but there is still some inaccuracy in the side-by-side SQL windows. If the column is way, way out of order in the second database, the comparison may pick this up as a new or missing column.

    This does not affect the comparison results or the SQL scripts that are produced, though. It's purely a cosmetic problem.
    · Share on Twitter
This discussion has been closed.