Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

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 


acceptance environment is


Are there database scripts to update all references in the acceptance database to point to instead of ?

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

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
Community showcase
Published in Confluence Cloud

🏠 Say hello to the new Confluence Home!

Hi Atlassian Community, My name is DJ Chung, and I’m a Product Manager on the Confluence Cloud team. Today, I’m excited to share a new and improved version of Home. The new Home helps you ...

954 views 7 42
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you