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/c ... 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/c ... Migrations