If you are on Jira Datacenter hosted in Azure and just looking to have a database disconnected from the production Jira database that you can pull data from copying the database using the native copy functions in Azure would be the way to go:
However, This would only be possible if you had direct access to a self hosted Data Center deployment on Azure, and would not apply to Jira Cloud, and this thread is flagged for Jira Cloud So I am not sure if this would apply to your setup. Also, data cloning from the API could be a possibility and I recomend looking at the following Documentation space to get started on setting up custom tooling, noting that there will be a lot of overhead in the process:
Additionally even for a locally hosted Jira instance I would still advise against trying to do your own reporting on a dedicated database. Unless you have the resources to understand the Jira database properly, and convert that into a custom data dictionary for your specific reporting requirements, and maintain the separate data clone every time JIRA is upgraded or a change applied like an add-on being installed there would be a ton of overhead to the process.
If more robust reporting is the goal, I would recomend either Looking into a paid third party Add-on app (as seen in this list) or using one of the free apps from atlassian to connect live Jira data into Excel or Google sheets where you can use those tools reporting capabilities to generate reports as needed. Check out "Jira Cloud for Google Sheets (Official)" and "Jira Cloud for Excel (official)" as alternatives.
Regards, Earl
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.