SQL Compare - changing nullability
The problem was the INSERT INTO portion of the code was failing saying that you couldnt insert null values into a non-null field, but there was a default value for the fields that were changed.
ie: IsShared, bit, nullable -> IsShared, bit, not null default 0
Now i hand tuned the scripts by adding IsNull([IsShared],0) to the insert into statements, but this isn't a sustainable solution.
Is there an option I overlooked? I tried a number of different things but no matter what i did the SQL scripts generated were not directly usable.