I am using SQL Data Compare to synchronize 8 tables between 2 instances of a system.
I have already used SQL Compare to ensure that the schemas are in sync but one of the tables prevents the package from running.
The table has 15 columns to compare and the PK is an identity column which i am using as the Comparison key. If i change the comparison to check just the PK column or the PK + an active flag column (bit) i still get the error.
The error is reported as coming from the source server instance, not the target but all it says is
"The following SQL command caused the error:
We have 4 different instances to do comparisons against and all of them exhibit the same behaviour regardless of which combination of source/target instance we use.