Tables Obviously Different but SQL Compare says are the same

daddyqbob50

I have two tables in two different SQL 2005 databases that are obviously different but SQL Compare does not show them as different no matter how many times I refresh the compare. Columns were added to the source database that are not in the target. The file diff at the bottom shows the differences.

I have version 5.3.0.44. The update says there are no updates.

JonathanWatts

Hi there,

The only thing that springs instantly to mind that would cause this behaviour is that you have a different column order in your tables, but the same columns. If this is the case then enabling the "Force column order" in the "Project Configuration>Options>More Options" dialog will ensure that the top grid detects this as a difference.

Otherwise, if you can provide a script example of both the tables, and what options are you running with we can have a go at working out what is going wrong?

Regards,

Jonathan

daddyqbob50

OK what I found is that the tables are equivalent but not the same. SQL Compare appended the new columns to the end of the column list. Other times it always put them into the same cardinal positions as in the source. I do not know why it did it this way this time. I had to manually sync the schemas in Visual Studio. Perhaps it is a bug.

daddyqbob50

That's it. I do not recall ever changing this option. Thanks.