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

SQL Compare fails due to applying null constraint to table

shiftbitshiftbit Posts: 12
edited March 8, 2013 1:58PM in SQL Compare Previous Versions
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?

Comments

Sign In or Register to comment.