Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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
Community showcase
Published in Bamboo

Bamboo 101 Video

G’day Community! As we gear up to introduce Bamboo Data Center to the world, we wanted to make sure that we shared a bit more about Bamboo, the product. Our team has put together an overview video ...

251 views 4 6
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you