Don't add error handling in command line generated deplymentscript

micke314

How do I remove the error handling from a script using the command line?

IF @@ERROR <> 0 SET NOEXEC ON

It works fine in the gui by checking "Don't add error handling statements to deployment scripts".
Looking at the project file makes me believe that NoSQLPlumbing is responsible for that but adding NoSQLPlumbing to the command line XML argfile does not seem to do much difference. I have not found anything in the documentation about this. Doesn't mean it's not there, I probably just need help finding it.

<Options>Default,NoSQLPlumbing,IgnoreCollations,CaseSensitiveObjectDefinition,DoNotOutputCommentHeader,IgnoreExtendedProperties,IgnoreFileGroups,IgnoreFillFactor</Options>

sam.blackburn

The option you're looking for is NoErrorHandling, described in more detail here.

micke314

Thanks! I somehow stumbled into the documentation for version 11 and did not notice.