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>;
Over the next several weeks we'll be sharing some of our Getting Started guides here in the community. Throughout this series of posts, we'd love to hear from customers and non-customers ab...
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