Bamboo does not have a built-in way to download only changes from any version control system (VCS). Though, you should be able to configure a series of custom script tasks using VCS commands (Git, SVN, etc) to detect any changes to the repository then pull only the changes.
Bamboo does not have a way to determine what changes were made to a repository between builds as Bamboo leaves the tracking of changes to repositories to the VCS. Perhaps the builds times could be queried from the Bamboo database and correlated to repository changes made afterward.
The following query should provide a list of code commits and commit files per build, and can be used as a starting point for the database deployment automation. Please note that the query may need to be adjusted slightly depending on the database server type being used.
FROM USER_COMMIT uc
JOIN REPOSITORY_CHANGESET rc ON (uc.REPOSITORY_CHANGESET_ID = rc.REPOSITORY_CHANGESET_ID)
JOIN BUILDRESULTSUMMARY brs ON (rc.BUILDRESULTSUMMARY_ID = brs.BUILDRESULTSUMMARY_ID)
JOIN AUTHOR a ON (a.AUTHOR_ID = uc.AUTHOR_ID)
JOIN COMMIT_FILES cf ON (uc.COMMIT_ID = cf.COMMIT_ID)
WHERE brs.BUILD_KEY = '<BUILD_KEY>'
AND brs.BUILD_NUMBER = <BUILD_NUMBER>;
Thanks for signing up for Jira Ops! I’m Matt Ryall, leader for the Jira Ops product team at Atlassian. Since this is a brand new product, we’ll be delivering improvements quickly and sharing updates...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs