How do I export all issues from particular project in JIRA DC

[RG]

Dear Experts,

I would like to export all issues from a particular project in JIRA data centre with all fields, all comments history and attachment reference links.

Purpose : Want to migrate data to Microsoft Dynamics

JIRA Version : 10.3.4 Datacentre

All comments and attachments are important for this export.

Please suggest how can we proceed with this.

Any script or 3rd party tool?

Thanks

[Gunjan Kumar · Accepted solution]

Hi RG,

Using JSON via the Jira REST API is the most reliable and Atlassian-supported way to export all issues from a project with all fields, full comment history, and attachment references.

The simplest and recommended approach is to use the Jira REST API with a JQL query (for example, project = KEY) to export issues in JSON format. This export includes all fields, complete comments, and attachment details with download links, so attachments can be downloaded separately. The normal CSV export from the Jira UI is limited and not suitable for migrations. Therefore, using the REST API and then importing the exported data into Microsoft Dynamics is the best solution.

[RG]

@Gunjan Kumar Thanks for suggestions. Could you please guide me with the steps/JQL. I am using one but not working as expected.

https://<BASE URL>/rest/api/2/search?jql=project=ABC

[Gunjan Kumar]

Use this one:

For 1000

https://<BASE_URL>/rest/api/2/search?jql=project=KEY&fields=*all&maxResults=1000&startAt=0

For more than 1000

https://<BASE_URL>/rest/api/2/search?jql=project=KEY&fields=*all&maxResults=1000&startAt=1000

[Marc -Devoteam-]

Hi @RG 

As mentioned by @Gunjan Kumar API is the most reliable.

Otherwise, search for issues via JQL and then export the results with all fields

[Dr_ Ankita Mehta-OpsHub_ Inc]

Hi @RG

Exporting a full project from Jira Data Center with all fields, comments, and attachment references isn’t fully covered by the standard export options, especially if the target is Microsoft Dynamics 365.

A few things to consider:

• Native export limits: CSV gives you issue data but not actual attachments, and XML backup is instance-wide rather than cleanly project-scoped.
• Downtime and disruption: Large exports can affect performance, so planning around usage windows is important.
• Attachments: In Jira DC, attachments live on the file system, so you need both database metadata and the physical files to preserve references properly.
• Comments and history: If full comment threads and change history are required, database-level extraction or a specialized tool is usually necessary.
• Data transformation: Dynamics uses a different schema, so structured field mapping and reshaping will be required.

In your case, you may want to explore OpsHub Migration Manager (OMM), Atlassian Solutions Partner. It supports project-level extraction, preserves comments, attachments, relationships, and history, and enables phased or full migrations without downtime, disruption, or data loss.

All the best!

[Aron Gombas _Midori_]

Microsoft Dynamics has extensive support for importing data from Excel files. (It is not surprising as both belong to MS, of course.)

You can export Jira issues with all fields, comments and attachment references to Excel files using the Better Excel Exporter app:

This route seems a relatively easy one to me, without coding required.

(Discl. this paid and supported app is developed by our team. Free for 10 users.)

[RG]

Hi @Aron Gombas _Midori_ How many issues can be exported at once? Are there any limitations?
We need to export all issues (approximately 28,000) from a specific project, including all fields, all comments, and attachment reference links.
We are  interested in this app, do you have any demo links available?

[Aron Gombas _Midori_]

 @RG 

Our app obeys the system limit configured for Jira, which is 1000 by default. But, you can easily set this to a higher value.

Many customers use the app to create very large snapshots of data. How many issues you can successfully export also depends on your server and the "nature" of your data, so "it depends". (Note that there are performance tuning approaches you can take if you have to.)

There is no demo site, but you can try the app any time using a free trial license generated from the app's Atlassian Marketplace listing.

I hope this helps.

[Natalia_Kovalchuk_SaaSJet_]

Hi RG!

If you need to export all issues from a particular project in Jira Data Center, including all fields and comment history, I recommend you try Issue History for Jira (Work Item History) app from the SaaSJet team. 

Using it, you will be able to do the following:

• Export full comment history (who added, edited, and when)

• Export complete change history (status, assignee, priority, etc.)

• Filter by project and date range

• Generate structured, export-ready reports in CSV or Excel formats.

Also, this article may help you to get the info related to other export methods: 5 Ways to Export Tasks and Project Data in Jira Data Center