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 2022 and may also work with other versions.



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.