How to add SQL task to execute sql scripts from a file using SQL for Bamboo app

This article explains how to add SQL task to execute sql scripts from a file using the app, SQL for Bamboo on Server.

Instructions

1. Log in as a Bamboo Administrator.
2. Ensure you have a project and a plan with respective stages and jobs configured. We shall use Project = Demo and Plan = Demo_plan in the below example:
   
3. Click on a job. In the example below, Demo_job2 > Add task > select SQL task
   

4. Provide all the details like description, Script location, Script, and database profile and click on Save as shown:
   

5. Below is the persons.sql file:
   

6. Now, click on Run plan for the SQL task to get executed.
   

   The output will result in the table creation in the database.
   
   
   

   • Ensure you have SQL for Bamboo app installed in your Bamboo instance.
   • If Script location is File, make sure to place the .sql file in that particular project with plan and job configured and directory, <BambooHome>/xml-data/builds-dir/project-plan-job>