Edit all links in Jira comments

Question

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.

nwylie · Answer

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

Alex Laycy_dvwa4f · Answer

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