tags:

views:

431

answers:

2
+1  Q: 

Using SQL for cleaning up JIRA database

Has anyone had luck with removing large amount of issues from a jira database instead of using the frontend. Deleting 60.000 issues with the bulktools isnt really feasible.

Last time i tried it, the jira went nuts because of its own way of doing indexes

+3  A: 

How about doing a backup to xml, editing the xml, and reimporting?

Joel Lucsy  2008-10-14 15:12:44
I have had success with this method, but never had the guts to try SQL on their schema.
dacracot  2008-10-14 15:26:09
The backup takes quite a while too, but this might be a usable idea
svrist  2008-10-14 15:58:10
+2  A: 

We got gutsy and did a truncate on the jiraissues table and then use the rebuild index feature on the frontend. It looks like it's working!

svrist  2008-10-14 15:59:13

related questions

Backup SQL Schema Only?
Sql to query a dbs scheme
Timer-based event triggers
Sql query, count and group by
Paging SQL Server 2005 Results
SQL 2005 For XML Explicit - Need help formatting
How do I use T-SQL Group By
What all do I need to escape when sending a (My)SQL query?
Split String in SQL
Datatable vs Dataset
ASP.NET MVC "CRUD" Database Sample
Convert HashBytes to VarChar
Best Book for a new Database Developer
What is the best way to avoid SQL injection attacks?
What language do you use for Postgresql triggers and stored procedures?
What is the best way to handle multiple permission types?
How do I index a database field
Swap unique indexed column values in database.
cx_Oracle - what is the best way to iterate over a result set?
cx_Oracle - How do I access Oracle from Python?
Is there a version control system for database structure changes?
How to export data from SQL Server 2005 to MySQL
ASP.NET Site Maps
Decoding T-SQL CAST in C#/VB.net
Flat File Databases in PHP