Ignore the order of columns in a table during comparison.

almalm Posts: 3
edited April 15, 2010 8:22AM in SQL Compare Previous Versions

How do i get SQL Compare 8 to ignore the order of columns, Constraints / Indexes and Foreign Keys in a table during the comparison?
Not during synchronization.

Tabels is identical, except from ordering, so i would like SQL Compare to ignore this type of difference.

In Options
"Force Column Order" is not checked. (I beleave this i for synchronization)



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

    The column order is ignored by SQL Compare unless the "force column order" setting is used. The problem that you experience probably has to do with the SQL code windows that you see after comparison. They will try to reorder the columns, but "give up" if the ordinals differ by four or more positions. Since this only affects the text representation and not the internal synchronization or comparison bits of the program, it will not cause SQL Compare to try to rebuild the table when synchronizing and it won't show that the table is different overall if column order is the only difference.
  • Options
    Thank you Brian!
Sign In or Register to comment.