Howto update links in the acceptance database (copy of production)

[Erik Mathijs]

For the preparation of my cloud migration, i want to setup a test environment for jira and confluence. Just for testing all cleanup steps. I don't want them to do in production before testing.

I asked a copy of the database scheme's from jira and confluence but in the tables are links stored to the url from production.

My production environment is 

• https://jira.int.mycompagny.be
• https://wiki.int.mycompagny.be

acceptance environment is

• https://jira-test.int.mycompagny.be
• https://wiki-test.int.mycompagny.be

Are there database scripts to update all references in the acceptance database to point to https://jira-test.int.mycompagny.be instead of https://jira.int.mycompagny.be ?

My current versions are

• Jira 8.20.2
• Confluence 7.13.1

I don't know in wich tables all references are stored.

These scripts woud be a great value to me.

Thanks in advance for input !

[Nic Brough -Adaptavist-]

There are a number of places this might be stored, but the main one you need to worry about is bodycontent - that contains your physical page content.

You'll need to find and replace all the links in large blocks of text though, it's not a simple update.