We got bit by a default value in a DMS task where the target column didn't exist so the data wasn't replicated and the default value was "this work needs to be done."

This is not pb nor go. A sensible default of invalid state would have caught this. So would an error and crash. Either would have been better than corrupt data.

▲

OrangeDelonge 5 days ago | parent [-]

You mean aws dms insterted the string literal “this work needs to be done” into your db?

	▲	sethammons 5 days ago \| parent [-]
		So, that target column was called the wrong name, meaning data intended for the column never arrived, causing the default value in the database to be used, which was an integer that mapped to "this work item needs to be processed still" which led to double processing the record post dms migration