ira SD : To cleanup the ticket data in Jira Database

[Channa patna]

Jira SD : To cleanup the ticket data in Jira Database-

Team, we have a scenario where all the Jira SD data ( in Jira Database ) will be copied from one Environment(A) to another Environment(B).

Once the data copied or migrated, to Environment(B), we need to cleanup all the Ticket data and retain only the Configurations, so new Data can be populated when this environment is made available for use.
Please let us know on how to Clean-up/Delete the data without deleting the Configurations made.

NOTE: We have used multiple plugins such as ScriptRunner, JSU Plugin and IssueSync for Configurations.
Any help is much appreciated.

[Nic Brough -Adaptavist-]

Do not touch the database, you will almost certainly corrupt it beyond use if you amend the database directory.

Once you've moved copied your Jira data from A to B (I assume B is an empty Jira), to delete the issues, use the UI delete either the issues from a project, or the whole project.  Deleting a project will delete all its issues, and the project header, so there is no project there any more, but all the configuration such as schemes, workflows, screens, and fields will remain in place, even if they're no longer associated with any projects.

Scriptrunner can help you bulk delete issues if necessary.