Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal


  • Give kudos
  • Received
  • Given


  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

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

Taking Prod to Dev

Hi, we have Confluence 6.2 and Jira 7.3.4 installed on a Windows 2012 data centre server hosting the MSSQL databases too.

We have a Development server installation of 6.2 too but it is long out of step with Production and I want update it with a copy of current Production. 

Question: How best to do this? 

If I do an SQL database restore, do I need take all the home directory and attachments too?  I am concerned with taking production environment settings across to Dev and not knowing to repoint them etc running risk of updating Prod with work done in Dev.  So I'd need understand what configs I need change.  I don't find this info very evident in Atlassian documentation.

Or I could do an XML export/Import which was my preferred method as being a dev environment I am not overly concerned with the add-ons working immediately.  We don't have a massive site, it's been operational since 2011 but only by less than dozen users.

Question:  I am only member of Confluence-Administrators so can I confirm I am blocked from doing any backups/restores anyway at moment and need bumping up to System administrator group which obviously I can't see to add myself to




2 answers

1 accepted

0 votes
Answer accepted

Hi @Richard ,

Useful link

Different sys admin and admin

To migrate may used XML backup and database backup. I have experience in both way, cannot say which better. It depend from many factors.

In any case  I recommend training on test environment. 


Hi, thanks.  I will give it a review. 

HI, do you know answer to Q2 too?  regards only being member of confluence-administrators.


Neither I or the other admin can see any System-Administrator group or permission so wondering if the previous admin whom left company had this permission and not transferred it to anyone upon leaving. 

Hi @Richard ,

'confluence-administrators' by default should has 'system admin' check please in 'Global permission'?



Ah ok, I understand now but all the documentation doesn't make that clear, it makes it sound like a separate selectable group that you'd see on the left but it is in fact just a tick box on the main screen as you show.  Obvious when you see it but otherwise it's a stupid confusing way of discussing it



0 votes

Hello @Richard I am a product manager in Atlassian.  Would you be willing to have a phone conversation about your requirements for test environments?   If you are please send me an email at: Fselvas at Atlassian dot Com to coordinate a time and day that is convenient for you.  Thank you in advance 

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted in Confluence

What do you think is the most *delightful* Confluence feature? Comment for a prize!

- Create your own custom emoji 🔥 - "Shake for Feedback" on mobile 📱 - An endless supply of GIFs via GIPHY 🤩 Is there anything quite as nice as a pleasant surprise? Comment below with what...

462 views 24 9
Join discussion

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