Option to use the default value or empty string for a NOT NULL column in the target DB that contains NULLs in the source DB
If the target DB has some columns that don't allow NULLs, but they did in the source DB, the inserts fail as it tries to insert NULL.
I think there should be a configurable option to make it either use the default value of the column or an empty string in place. As part of the insert the script could be ISNULL(ColumnName, 'DefaultValue').
Many thanks.
5
votes
Xander Harrison
shared this idea