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

ANSI_WARNINGS Project Option

s_solts_solt Posts: 11
edited March 22, 2013 1:23PM in SQL Compare Previous Versions
NB I couldn’t find a wishlist on the support forums.

For several years I have wanted a project option to set ANSI_WARNINGS OFF when I am happy to ignore data truncation warnings. I know I can (and do):

• Copy the script to the clipboard
• Paste it into SSMS
• Edit two lines
• Execute it
• Go back to SQL Compare
• Close the deploy dialog
• Recompare

But this is a bit of a performance, particularly if I am using repeated deployment attempts fixing each error in turn that prevents the synch in order to identify all the issues other than those related to data truncation.

Stephen Solt
Planchest Ltd
Sign In or Register to comment.