Refs #2648 - re-arrange validation - data must be compatible with new datatype before modifying the tables or column definitions, data can then be set to proper values after the table/column alterations are complete.