Modifying Tables and Using Bulk Copy

Modifying either the length or datatype of a column may prevent you from successfully using bulk-copy to copy in older dumps of the table.

The older table schema may not be compatible with the new table schema. Before you modify a column’s length or datatype, verify that doing so does not prevent you from copying in a previous dump of the table.