How to add a SQL task to run SQL scripts from a file using SQL for Bamboo

This article explains how to add a SQL task to run SQL scripts from a file using the SQL for Bamboo app on server.

Instructions

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

4. Provide SQL configuration details and click Save.
   

5. Consider an example persons.sql file:
   

6. Click Run plan to run the SQL task.
   

   The output results in the table creation in the database.
   
   
   

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