This article explains how to add an a SQL task and execute the single to run SQL scripts from a file using the app, SQL for Bamboo on Server SQL for Bamboo app on server.
Instructions
- Log in as a Bamboo administrator.Navigate to > Add-ons > Find new apps and search for "SQL for Bamboo". Ensure you have SQL for Bamboo app installed in your Bamboo instance.Ensure you have a project and a plan with respective stages and jobs configured. We shall use
- Use Project = Demo and Plan = Demo_plan as mentioned in the in the example below example:
- Click on a job. In the example below, Demo_job2 > Add task > select SQL task.
Provide all the details like description, Script location, Script, and database profile and click on Save as shown:
Below is the resultantSQL configuration details and click Save.
Consider an example persons.sql file:
Now, click on Click Run plan for to run the SQL task to get executed.
The output will result results in the table creation in the database.
Note If Script - 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>.