When migrating "data only", if the columns within a table are in a different order between the source database and destination database, errors are encountered when migrating the data. The errors are "unexpected EOF encountered
in BCP data-file" or "Invalid field size for datatype".
I updated the column order in one database to match the other and the data was successfully migrated.
Is the column order requirement here to stay? Configuration option I haven't set?
Apologize in advance if this question has already been asked.