Navigation:  Actions > Server >

Run SQL Action

Previous pageReturn to chapter overviewNext page

The Run SQL action creates a step to run SQL scripts against a Microsoft SQL Server database.  It generates a SQLCMD statement from the inputs and runs it.  The SQL script can be provided within the step (using the built-in editor with SQL syntax highlighting) or by referencing a separate file containing the script.

 

Server tab

 

Input tab

 

Output tab

 

Options tab

 

Advanced Tab

 

Remote Tab

 

This action requires the SQL Server client tools to be installed.  It has been tested with SQL Server 2000 thru 2017 and may also work with other versions.

 

Notes:

Use the ADO action for querying a SQL Server database or modifying or querying other databases from a build.
See the Server.bld sample for a project utilizing this action.