SQL data compare int data type in source and bit in target?

ShilK

As per the allowed data types to be compared (https://documentation.red-gate.com/sdc11/troubleshooting/unexpected-behavior-technical-questions/which-data-types-can-be-compared) int data type in source and bit in target should be able to be compared. I am getting exclamation mark and does not allow me to select it to be compared. 

DanC

Hi @ShilK

According to the updated documentation page here: https://documentation.red-gate.com/sdc/troubleshooting/unexpected-behavior-technical-questions/which-data-types-can-be-compared

It's unfortunately, not possible to compare an int to bit.