Comparing source and target databases - schemas and table names are different so had to manually map. There is a record being included as insert that actually already exists in the target database and thus is raising a duplicate PK error on deployment. The comparison field I've set is a unique surrogate key, while the actual PK is a parent key and a start date. Regardless, the entire record appears to be identical between source and target. There are no other records on either side that share the same PK as this record.
Why isn't this being raised as an identical update rather than an insert? Makes me concerned about how the comparison is being made overall.
Why isn't this being raised as an identical update rather than an insert? Makes me concerned about how the comparison is being made overall.