Compare when Columns in different sequence
After my first couple of compares, it seems that SQL Compare has issues when comparing two tables with same column names but in different sequences.
In the result screen, SQL Compare is lining up and highlighting in dark orange a column called "Notes" to a column called "Invoice_Date". Even though "Notes" does exist in the second table, just in a different spot and "Invoice_Date" exists in the first table again just in a different spot.
For other columns that are in different order, SQL Compare highlights the column in first table then has empty space in second table (or vice versa). While this is ok, still rather difficult to read the results. For this comparison, I really do not care about the physical ordering of the columns
I cannot find an option to tell SQL Compare how to compare columns... column name versus column order. Is this possible? Since this seems like such a basic option, I'm hoping I'm just missing something. I've searched the help file on this but no luck.
Also,is there an option to display the comparison results with out displaying like a DDL statement? For this comparison, I would rather have the columns line up with the differences easily visible rather then see the CREATE TABLE command used to generate the table.
Any thoughts would be appreciated since this is causing a lot of extra work trying to wade through a bunch of false compare results.