Bulk edit of a deployment task?

burt repine

We have hundreds and hundreds of deployment plans that contain a task that uses a now defunct 'linked repository'.

We would like to have the tasks updated to use the new repository but were hoping for a non-manual way of doing it?

Thanks for the help.

Anik Sengupta

Hi Burt,

Thanks for your question.

May be you can try the workaround mentioned in the BAM -

https://jira.atlassian.com/browse/BAM-18273

This can be done using a database update:

1. Stop Bamboo
2. Back up your Bamboo database for restore/recovery purposes
3. Run the following update query, replacing <old-url> and <new-url> as needed:

PostgresDb:
update VCS_LOCATION as V

set xml_definition_data = replace(xml_definition_data,'<old-url>','<new-url>');

MSSQL Server: 

update VCS_LOCATION  set XML_DEFINITION_DATA = replace( cast( XML_DEFINITION_DATA as nvarchar(max) ),'<old-url>','<new-url>');

 Note: If you are using a port other than 22, you will also need to amend the port number to the new URL or configure port forwarding from the default port (22) as explained in this KB article.

4. Start Bamboo

Regards,
Anik Sengupta
**please don't forget to Accept the answer if your query was answered**