Ignore the order of columns in a table during comparison.
alm
Posts: 3
Hi!
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)
/Anders
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)
/Anders
Comments
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.