Hi ,
we have a 2 JIRA instance servers one with version 6.4.2 which has 2 projects and other JIRA server which is UAT has 7 projects with 6.4.7.
trying to move everything to one server, I did try to import using CVS importer from 2 projects with version 6.4.2 to uat server 6.4.7 ..was missing comments ,history and attachments...is there any way /workaround I can do it.
please help, Thanks!
Hi Tummala,
Yes, you are right. I forgot about that!
Via CSV, you can import comments and worklogs using a similar SQL:
Comments:
copy( select (project.pkey || '-' || jiraissue.issuenum ) as "Issue key" , ( '' ) as "Summary" , (jiraaction.created || '; ' || cwd_user.user_name || '; ' || jiraaction.actionbody) as "Comment Body" from jiraaction join jiraissue on jiraaction.issueid = jiraissue.id join project on jiraissue.project = project.id join cwd_user on jiraaction.author = cwd_user.email_address where actiontype = 'comment' and <other restricts for issues to have their comments imported>) to '/data/tmp/comments.csv' csv header; |
When importing, use this as time format:
dd-MM-yy HH:mm:ss.SSSX
Worklogs:
copy ( select (p.pkey || '-' || ji.issuenum) as "Issue key" , ( '' ) as "Summary" , (w.worklogbody || '; ' || w.created || '; ' || w.author || '; ' || w.timeworked) as "Worklog" from jiraaction ja inner join jiraissue ji on (ja.issueid = ji.id) inner join project p on (ji.project = p.id) where p.pkey = 'FTSI' and ji.issuenum in (211)) to '/data/tmp/workLogFTSI.csv' csv header; |
I'm not sure if there is a way to do the same with history (I don't think so). And for attachments you can just sync the folders between the servers.
Hi Tummala,
Did you try to perform a full backup of the JIRA source and then execute a project import on the target instance?
This should bring all data you mentioned.
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.