SQL Compare fails due to applying null constraint to table

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?

shiftbit March 06, 2013 12:44

Comments

1 comment

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

Manfred.Castro March 08, 2013 13:58

0

Add comment

Please sign in to leave a comment.

How can we help you today?

SQL Compare fails due to applying null constraint to table

Comments

Add comment