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 ?

Thanks

Comments

  • Eddie DEddie D Posts: 1,563 Rose Gold 4
    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
    Eddie Davis
    Product Support Engineer
    Redgate Software Ltd
    Email: [email protected]
Sign In or Register to comment.