We are planning to start out with a Jira 6.1 instance using a local MySQL DB for a team of 100 Developers, with plans to switch to an Oracle DB (running on a separate DB server) in a few months. Anyone have any concerns or know of challenges with this plan we should consider? Thanks in Advance!

Community
Q&A
Jira
Questions
Any challenges with switching DB from MySQL to Oracle?

How to keep few sub-tasks names same (of our choice) under a parent task?

I want to keep few sub-tasks names same under a parent-task. Not same as parent task, but different title than parent task. Also, not all sub-tasks should have same exact title.

I have ScriptRunner Server version. I am using JIRA 8.5.1 Server version.

I am a newbie in coding. Hence, I would need query which I can run using ScriptRunner console or wherever in JIRA.

Example: A parent task has 50 sub-tasks. Out of these 50 sub-tasks, the query should allow me to mention comma separated IDs of sub-tasks for which I want to keep title as "Test-123".

The query should only impact title of the sub-tasks mentioned in the query and rest sub-tasks titles should be intact.

How can I achieve this?

Thanks,

Kaushik.

3 answers

1 accepted

1 vote

Answer accepted

Hi Dave,

It's hard to say that you will not face any challenges during the database migration.

But the process itself usually is pretty simple, JIRA has a XML Backup engine, which exports all your data, and also imports it, doing all the necessary adjusts to place your data in whichever database it's connected.

So basically, what you will need to do is:

1. Export your Mysql XML Backup.

2. Setup your Oracle clean database (follow this document: Connecting JIRA to Oracle.)

3. Connect JIRA to this new Database.

4. Import your XML Backup.

I hope it helps!

Best Regards.