What are the challenges you face when working across database platforms? Take the survey
Options

Cannot insert the value NULL into column 'create_dt'

AmiWAmiW Posts: 4
edited April 24, 2015 7:03AM in SQL Compare 11
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?

Comments

Sign In or Register to comment.