Jira test environment for upgrade. Same DB but different schema

Hi everyone, I need to create a JIRA test environment to try the upgrade from v5.2.10 to v6.2.1

Will I have trouble doing this if I use the same Oracle database as Prod but different schema? Is this possible?

We are a little short on resources to have a new database, that's the reason why DBA people are asking me if we can use a different schema.

Thanks in advance.

1 answer

1 accepted

2 votes
Accepted answer

Hi Ramiro,

Yes this possible definetively possible but be aware your are taking risk ...

Just copy your schema and point on the correct one define in your jira-home :dbconfig.xml


Thanks Sven.

What would be the changes I have to be aware of? Is pointing correctly in dbconfig.xml the only modification I have to do?

If I update the version in this new schema won't change nothing on the prod schema?

Are you running only the DB on the same box ?

The apps is on different box ?

If by different box you mean different servers then yes. I have to different servers for my JIRA prod and my Test Environment, and I have another one for my database.

in this case, yes definetely just : dbconfig.xml

don't forget to change your base URL and remove/change your mail server as well.

Should I change the base URL and remove the mail server after changing dbconfig.xml?

yes, the best is to do it before (by applying sql to your db) starting your test instance to avoid any conflict with your production.

Thanks Sven! I'll give it a try. Thank you for your time!

just for your info :

delete * from mailserver;
update propertystring
set PROPERTY_KEY = 'https://mytest.com'
where PROPERTY_KEY = 'https://myproduction.com';

Is this property_key the base URL?

Since DBA didn't warned me that the test environment was connected to the prod DB and Schema, when I changed the base URL of the test environment a week ago maybe I changed the base URL of JIRA prod. Is this possible?

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Nov 27, 2018 in Portfolio for Jira

Introducing a new planning experience in Portfolio for Jira (Server/DC)

In the past, Portfolio for Jira required a high degree of detail–foresight that was unrealistic for many businesses to   have–in   order to produce a reliable long-term roadmap. We're tur...

2,741 views 17 21
Read article

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you