Edit all links in Jira comments

[nwylie]

We are moving our backend storage provider and Im looking for a way to change all the links to the new locations.

We have a document tracking old link location and then new link location. For confluence I am performing an XML dump then applying a sed loop to find replace. 

The Jira equivalent seems to be a SQL dump and then sed, but has anyone done any online changes? Perhaps a similar loop but with an alter statement?

Trying to avoid downtime as much as possible.

[Alex Laycy]

Hi @nwylie ,

Just to clarify/confirm, is it the links within your external document that you're looking to update? 

What tool or service is this document making use of? (Excel, G Sheets etc?)

- Alex

[nwylie]

Hi Alex, 

Right now people link to box.com for their documents from jira comments. We are migrating these to onedrive, so the URLs for the links need to change.

We will have a document with the old (box) url and the new (onedrive) url and my current plan is to use a mysql (our db) REPLACE loop for these or a dump + sed.

Can you think of any other, better, way to handle this?

Thanks,

Neil