SQL Compare fails due to applying null constraint to table

[shiftbit]

I am trying to deploy changes FROM a live database, so my local instance that I got from a test server. I want to slap all the differences onto my local instance and start my changes from there. So I started SQL Compare and tried to apply the changes and got the following error (table/column names removed).

So I was reading this article
http://www.red-gate.com/supportcenter/content/SQL_Source_Control/help/3.1/SSC_Working_With_Migrations

Cannot insert the value NULL into column '...', table '...'; column does not allow nulls. UPDATE fails.

How do I build/specify a migration script with SQL Compare? I seen a place to use it with SQL Source Control, but not compare?

[Manfred.Castro]

You cannot create migrations scripts in SQL Compare. You use SQL Source Control to create migrations scripts and commit them to your repository. SQL Compare is then used to create the deployment script.
http://www.red-gate.com/supportcenter/content/SQL_Source_Control/help/3.1/SSC_EG_Deploy_Migrations
_________________
Manfred Castro
Product Support
Red Gate Software