Recovery tables do not set defaults on not null columns

gacracker777

Is there a setting that will tell the compare to set a default on 'NOT NULL' columns ?

When i run sqlcompare that creates the scripts there are times when a recovery table is needed. When the recovery table is created it should set an assumed default on 'NOT NULL' columns. Otherwise the script will fail on NOT NULL columns.

Is there a setting for this situation ?

What is your recommendation for resolution ?

Thanks

Eddie D

Hi, thank you for your forum post.

Not sure what you mean by a recovery table. Are you referring to temp table that is created when adding a new column to an already populated table and the new column does not allow nulls? If the answer is yes, to fix this:

• assign a default value to the column in the source database, or
• set the column to allow nulls, and then set it back after you have the correct data inserted.

There is no feature or option in SQL Compare to set a default value.

Many Thanks
Eddie