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?