Column Order?
PaulyW
Posts: 7
Hi,
Maybe I'm being thick but I've never found an option in SQL Compare to sort table columns by name in the source. This is something that would have got me out of a muddle many times in the past ....
In the scenario where I'm checking data types in the same table across two databases ideally I would like all matching columns (based on name in the source objects) to be shown first and on the same row as each other to aid that process..
At the moment if the column order is different between the tables then it totally throws out the visual representation of the results and I'm scrolling up and down trying to find matches between the two (on name) to check that datatypes are the same.
This is what I'd like:
ColA ColA
ColB ColB
ColC ColC
ColD ColD
ColA3
...
But this is generally what SQL Compare shows (not entirely sure why there's sometimes a gap in the 'destination' column list...):
ColA ColA
ColA3 ColB
ColB ColC
ColC ColD
...
If it can be done then would love to know how. If it can't, could I suggest it as a new feature?
Maybe I'm being thick but I've never found an option in SQL Compare to sort table columns by name in the source. This is something that would have got me out of a muddle many times in the past ....
In the scenario where I'm checking data types in the same table across two databases ideally I would like all matching columns (based on name in the source objects) to be shown first and on the same row as each other to aid that process..
At the moment if the column order is different between the tables then it totally throws out the visual representation of the results and I'm scrolling up and down trying to find matches between the two (on name) to check that datatypes are the same.
This is what I'd like:
ColA ColA
ColB ColB
ColC ColC
ColD ColD
ColA3
...
But this is generally what SQL Compare shows (not entirely sure why there's sometimes a gap in the 'destination' column list...):
ColA ColA
ColA3 ColB
ColB ColC
ColC ColD
...
If it can be done then would love to know how. If it can't, could I suggest it as a new feature?
Comments
The work we have done on the UI will allow us to make significant changes to the diff viewer in future. In particular, we would like to implement a semantic diff view that would ignore purely textual differences in an object's definition, such as column order in a table.