Export JIRA On Demand Back up as text file

[Daniel Kerns]

Is it possible to export a back up for the JIRA database as a text file?

[Daniel Kerns]

Thank you for the info. My team is trying to pull the data from JIRA On Demand into a dataware house. The IT team importing the data has requirements the feed to be in a text file.

Is there an easy way to pull the data for each table with headers in a text file?

[MatthewC]

There is XML export for the whole system

https://confluence.atlassian.com/display/AOD/Exporting+issues

or there is exporting search results as Excel

https://confluence.atlassian.com/display/AOD/Exporting+Search+Results+to+Microsoft+Excel

Word

https://confluence.atlassian.com/display/AOD/Exporting+Search+Results+to+Microsoft+Word

It really depends on what you are after. perhaps if you could add some more detail on your requirement?

[MatthewC]

Ok, from your question below... so you are leaving on Demand and going back to an in-house hosted database and version of Jira?

I guess I have to ask, what is the data warehouse for? What are you going to be doing with the data?

if you are keeping onDemand and putting the data into the warehouse for company reason, you could do a search for all issue, export to Excel and send that across

if you want a working Jira database in your company, then do an XML export, set up a local Jira install, re-import the XML data into it. You can then run your extract against a local database e.g. MySQL running on a desktop

[Nick Mason]

The export is done as an XML file, if that's what you mean. What are you trying to accomplish?