Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,460,434
Community Members
 
Community Events
176
Community Groups

Bulk change the Bitbucket/Stash URL in Bamboo for all the jobs/plans

Fellas,

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:

  • Will changing the application link to stash repo suffice for the job to use the new Stash repo? 
  • Do we need to individually change the "Repository URL" for all the linked repo?

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.

1 answer

0 votes
Jeyanthan I Atlassian Team Sep 29, 2020

Hi,

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:

  • Stop the Bamboo server.
  • Run the below query.
    SELECT * FROM VCS_LOCATION WHERE 
            XML_DEFINITION_DATA LIKE '%<old-URL>%';
    
  • Verify from the result if you have old entries in the XML_DEFINITION_DATA column.
  •  Take a backup of the database just in case if something goes wrong.

  • Run the below query to update those entries you found in the previous comment.
    UPDATE VCS_LOCATION SET XML_DEFINITION_DATA=REPLACE(XML_DEFINITION_DATA,'<old URL>','<new IPaddress/URL>');
    
  • Re-run the select statement and confirm that you do not have any entries listed.
  • Start the Bamboo server.
  • You might want to resave al these repositories manually to recreate SSH keypair.

Hope that helps.

Cheers,
Jey

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events