Page Comparison

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

Instructions

1. Log in as a Bamboo administrator.Navigate to Image Removed > 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 configured with stage respective stages and job.(in the example using Project: jobs configured.
2. Use Project = Demo and Plan : = Demo_plan)
   Image Removed as mentioned in the in the example below:
   Image Added
3. Click on job(in example a job. In the example below, Demo_job2 )→ > Add task → task > select SQL task.
   Image RemovedImage Added

4. Provide all the details(like description, Script location, Script, and database profile) and Save as shown:
   Image Removed

   Below is the

   SQL configuration details and click Save.
   Image Added

5. Consider an example persons.sql file:
   Image Modified

6. Click on the Run plan, for Click Run plan to run the SQL task to get executed.
   Image RemovedImage Added

   The output will result results in the table creation on in the database side.
   Image Modified
   
   

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