Cannot insert the value NULL into column 'create_dt'
AmiW
Posts: 4
How to deploy?
tableabc in prod has data.
tableabc in dev has additional column "create_dt" with not null and no default value constraint.
I kept getting error:
SQL Compare aborting because Cannot insert the value NULL into column 'create_dt', table 'xyxz.dbo.RG_RECOVERY_1_tableabc
Cannot insert the value NULL into column 'create_dt', table xyxz.dbo.RG_RECOVERY_1_tableabc'; column does not allow nulls. INSERT fails.
Applications development completed with the insert calling getdate().
There are 50+ tables with this situation. Is there a quick way to deploy the additional column without doing it manually?
tableabc in prod has data.
tableabc in dev has additional column "create_dt" with not null and no default value constraint.
I kept getting error:
SQL Compare aborting because Cannot insert the value NULL into column 'create_dt', table 'xyxz.dbo.RG_RECOVERY_1_tableabc
Cannot insert the value NULL into column 'create_dt', table xyxz.dbo.RG_RECOVERY_1_tableabc'; column does not allow nulls. INSERT fails.
Applications development completed with the insert calling getdate().
There are 50+ tables with this situation. Is there a quick way to deploy the additional column without doing it manually?
Comments