Jira database question

Question

Hi All,

we have a Jira with Postgres DB.

We need to change the screen scheme for 130 projects which would be too much effort via the GUI one-by-one.

Is it possible to change the screen schemes in DB?

Thanks,

Rumi

Naren3 · Accepted Answer

You should be able to update the screen schemes using back end approach.

* Test this approach successfully on the test JIRA env. DB first.
* Make sure you backup the JIRA before handling Live JIRA DB 
* Shut down JIRA during modifying the database.
* Restart and re-index JIRA after modifying the database.

Have a look at the below links before taking this approach

JIRA Database Schema

Example SQL Queries for JIRA

Returning info on project's screen, tabs and fields