/
How to add a SQL task to run SQL scripts from a file using SQL for Bamboo
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
- Log in as a Bamboo administrator. Ensure you have a project and a plan with respective stages and jobs configured.
- Use Project = Demo and Plan = Demo_plan as mentioned in the in the example below:
- Click a job. In the example below, Demo_job2 > Add task > select SQL task.
Provide SQL configuration details and click Save.
Consider an example persons.sql file:
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 directory, <BambooHome>/xml-data/builds-dir/project-plan-job>.