Versions Compared

Old Version 4

changes.mady.by.user Amulya Akula (Inactive)

Saved on

compared with

New Version 5

changes.mady.by.user Amulya Akula (Inactive)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This article explains how to add 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, plan configured with stage and job.(in the example using Project: Demo and Plan: Demo_plan)
  4. Click on job(in example Demo_job2)→ Add task → select SQL task

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

  6. Below is the persons.sql file

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

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

    Note

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