Navigation: Actions > Server >
Run SQL Action
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.
This action requires the SQL Server client tools to be installed. It has been tested with SQL Server 2000 thru 2019 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.|