Page Comparison

This article explains how to add an SQL task and execute the single file using the app, SQL for Bamboo on Server.

Instructions

1. Log in as a Bamboo administrator.
2. 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.
3. Ensure you have a project , and a plan configured with stage respective stages and job.(in the example using Project: jobs configured. We shall use Project = Demo and Plan : = Demo_plan )in the below example:
   
4. Click on a job(in example . In the example below, Demo_job2 )→ > Add task → task > select SQL task
   

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

6. Below is the resultant persons.sql file:
   

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

8. The output will result in the table creation on in the database side.
   
   
   

   Note
   If Script location is File, make sure to place the .sql file in that particular project with plan and job configured and directory, directory  <BambooHome>/xml-data/builds-dir/project-plan-job>