Redgate Compare
I am using RedGate SQL Compare 11.6 to compare two SQLServer 2016 databases.
The problem is, the comparison result includes tables that have same columns but in different order. I would like to exclude this. Is there a way to do these?
ID then next to activate it. Microsoft office 2013 install with key code. ENJOY YOUR OFFICE 2013 I hope you will find right microsoft office 2013 product key.
RedGate's Support forum and help documents say that 'Default behavior is to ignore such differences' But it doesn't seem to work like that.
1 Answer
By default it doesn't compare column order. To validate this, I set up a test this way using SQL Server 2016 & Compare 11.6:
One of the huge perks in using the file manager in fsd is the multi select feature.However I like to keep xex menu around as a backup. Descargar xexmenu 1 2. In fact I used it the other day when i was upgrading my xbox hdd from a 20gb to a 60gb.
When I ran compare against the two tables, the output was here:
If you note at the top, it says there are 24 identical objects. These two tables count as identical. However, compare does note that the column order is different. There's an option you can set 'Force Column Order' that changes this behavior. When that's enabled you would see this from the comparison:
It's possible that's what you're seeing. Check the options on the Compare project.