You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
We are migrating our Stash/Bitbucket repo from in house to a cloud environment this weekend and with migration the URL of the Stash/Bitbucket URL will change.
Following are a few questions, the answers to which we still haven't figure out yet:
If we need to individually change the "Repo URL", is there a way we can change the Stash/Bitbucket URL in Bulk by running a SQL script on Bamboo database?
We have few repo that utilizes the application link and few which actually use an explicit "Repository URL", we are not that concerned for the former but are a bit concerned on how to seamlessly make this transition for the latter.
Any help would be appreciated.
Will changing the application link to stash repo suffice for the job to use the new Stash repo?
It is not sufficient to recreate the application link.
Do we need to individually change the "Repository URL" for all the linked repo?
Not necessarily. You can do this directly on the database to perform a bulk update of the repository URL. We have an open feature request - BAM-18273 to make this change easier.
Below are the steps to follow in the meantime:
SELECT * FROM VCS_LOCATION WHERE XML_DEFINITION_DATA LIKE '%<old-URL>%';
Take a backup of the database just in case if something goes wrong.
UPDATE VCS_LOCATION SET XML_DEFINITION_DATA=REPLACE(XML_DEFINITION_DATA,'<old URL>','<new IPaddress/URL>');
Hope that helps.