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

Two Column are the same

Rand626Rand626 Posts: 2
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.

Art Lorenzini
State of South Dakota
DBA Group
Aberdeen, Sd


  • 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.
This discussion has been closed.