SQL Compare fails due to applying null constraint to table

Forum for users of SQL Compare schema synchronization utility

SQL Compare fails due to applying null constraint to table

Postby shiftbit » Wed Mar 06, 2013 5:44 pm

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?
Posts: 9
Joined: Tue Mar 05, 2013 11:37 pm

Postby Manfred.Castro » Fri Mar 08, 2013 6:58 pm

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
Product Support
Red Gate Software
Posts: 209
Joined: Mon Apr 23, 2012 1:49 pm

Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests