Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Making sense of the comparison results

Columns are marked as different but they seem to be identical! In some cases you may see a table pair marked as different and when you look at the "Schema Differences" tab on the bottom you may notices that one or more columns have been highlighted as being different but there is no visible difference on the script! In these cases you will need to dig deeper to find out why those columns are marked as different. To do that expand the table on the top section and then click on the column you are interested on - on the bottom section of the screen you will see the script for that particular column with the different section highlighted. This difference will be visible on the table script as well however it is a lot easier to "spot" on the column script.

...

Scroll pdf ignore

Total compare from data to schema with IDERA SQL Comparison Toolset. Learn more > >