I have searched the Redgate Forums and online documentation for an option to switch on the "WITH VALUES" option.

When deploying a table change which contains a new column (which has a default specified) I would appreciate the ability to have the "WITH VALUES" added automatically to chosen columns.

Perhaps someone can point me to where I have missed this in the documentation and in SQL Compare 12.

Regards

Trevor
McComb
0

Comments

3 comments

  • Anu D
    Hi Trevor,

    Thanks for your post!

    SQL Data Compare looks up on Source to provide the data hence there is no option in the tool.

    If you think this is useful can you post this feature on our User-voice website?

    At the moment you need to edit the script generated by SQL Data Compare in order to get this option in.

    Hope this helps.
    Anu D
    0
  • McComb
    Request added to SQL Compare 12 functionality requests.
    McComb
    0
  • McComb
    Still not available
    McComb
    0

Add comment

Please sign in to leave a comment.