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

Adding NON-NULL columns

Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
edited August 12, 2004 11:51AM in SQL Compare Previous Versions
Hi Vlad,

When you're migrating a new column from one database table to another
one, the only way to keep the error from happening is to add a default value
in the source table. This will populate the new column with rows of the
default value so that the script will not fail due to the violation of the
NOT NULL constraint.

Kind Regards,

Brian Donahue
Red Gate Technical Support

"Vlad" <REMOVE_THISvladco@comcast.net> wrote in message
> Is there any way to have a NON-NULL columns added to tables that already
> have rows?
> Right now SQLCompare issues a warning that the update might fail...
> If that cannot be done what would be the workaround?
> Thanks,
> Vlad
This discussion has been closed.