Wiki

Clone wiki

jira-threaded-comments / Migrating From Atlassian Labs Add-on

In case you are migrating from the existing JIRA Threaded Comments by Atlassian Labs to this add-on, please follow the below steps for migrating the data:

  • Uninstall the Atlassian Labs add-on.
  • Install this add-on.
  • Shutdown JIRA.
  • Run the below SQL commands in the JIRA database

PostgreSQL

#!SQL

insert into "AO_0C0737_COMMENT_INFO"("COMMENT_ID", "ISSUE_ID","PARENT_COMMENT_ID") SELECT "COMMENT_ID", "ISSUE_ID","PARENT_COMMENT_ID" FROM "AO_CFEE31_COMMENT_INFO";
insert into "AO_0C0737_VOTE_INFO"("COMMENT_ID", "ISSUE_ID","USER_NAME","VOTE_COUNT") SELECT "COMMENT_ID", "ISSUE_ID","USER_NAME","VOTE_COUNT" FROM "AO_CFEE31_VOTE_INFO";

MySQL

#!SQL

INSERT INTO AO_0C0737_COMMENT_INFO(COMMENT_ID, ISSUE_ID,PARENT_COMMENT_ID) SELECT COMMENT_ID, ISSUE_ID,PARENT_COMMENT_ID FROM AO_CFEE31_COMMENT_INFO;
INSERT INTO AO_0C0737_VOTE_INFO(COMMENT_ID, ISSUE_ID,USER_NAME,VOTE_COUNT) SELECT COMMENT_ID, ISSUE_ID,USER_NAME,VOTE_COUNT FROM AO_CFEE31_VOTE_INFO;
* Restart JIRA.

Updated