Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Erik Mathijs
Contributor
December 10, 2021

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 !

 

1 answer

0 votes
Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 12, 2021

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.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
TAGS
AUG Leaders

Atlassian Community Events