Jira database question

[Rumceisz]

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

[Naren · Accepted solution]

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