Adding NON-NULL columns
Brian Donahue
Posts: 6,590 Bronze 1
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
news:z7bn1i%23fEHA.1620@server53...
> 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
>
>
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
news:z7bn1i%23fEHA.1620@server53...
> 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.
