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.