scriptrunner

[Dasari Sravanthi]

Hi team, I am working on Jira server to cloud migration. I wamt premigration data from Database. But I dont have server access to login to Jira DB. Can I use script runner and select local DB to run SQL queries? Is local DB in scriptrunner gives the same information which can we run on Jira DB? Is local database in script runner says that  we can run queries and get the data within this Atlassian application and is that refers to Jira database ? Please help me in that it will save more time to get the data in Jira I want for migration

[Nic Brough -Adaptavist-]

Welcome to the Atlassian Community!

Generally, for a migration, you shouldn't be looking at the database.  It's going to be quicker and easier to understand if your admins just look around the system, and maybe consider installing one of the admin helper apps (my own lot have "microscope" which gives you a load of detail that's useful for preparing a migration)

[Dasari Sravanthi]

Thank you for the information, Nic. But with this microscope app I am not getting the premigration checklist data in which it includes dashboards, filters, agile boards shared with anyone status how to find that and how to resolve it without database? Please help  me with some information on this.

[Nic Brough -Adaptavist-]

Microscope only gets you some of the information.  We've got a pile of improvement requests for more of it to work through, but for the things that are not not in it, you should log in as an admin and simply read the lists.

Physically looking at each one is a more simple and quicker way to get the info you want than reading the database.