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

Recovery tables do not set defaults on not null columns

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 ?



  • Options
    Eddie DEddie D Posts: 1,793 Rose Gold 5
    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 Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.