Jira test environment for upgrade. Same DB but different schema

[Ramiro Pointis]

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.

[Sven [Dione Technology] · Accepted solution]

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

Sven.

[Ramiro Pointis]

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?

[Sven [Dione Technology]]

Are you running only the DB on the same box ?

The apps is on different box ?

[Ramiro Pointis]

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.

[Sven [Dione Technology]]

in this case, yes definetely just : dbconfig.xml

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

[Ramiro Pointis]

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

[Sven [Dione Technology]]

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.

[Ramiro Pointis]

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

[Sven [Dione Technology]]

just for your info :

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

[Ramiro Pointis]

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?