WITH VALUES

McComb

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

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.

McComb

Request added to SQL Compare 12 functionality requests.

McComb

Still not available