2.4 to 3.0 Migration

294
Task
Jack
Jack
3.0
2.4.0
Install/Upgrade
Completed
Highest
Normal
4 years ago
3 years ago
0

Description

The migration system for Traq 2.4 to 3.0 needs to be done.

Ticket History

4 years and 9 months ago by Tomasz Fidos

As a workaround i created some sql code to migrate data after successfull traq 3.0 installation.

Use it at your own risk :) [code] -- Attachements INSERT INTO traq3_attachments SELECT id,name,contents,type,size,owner_id user_id,ticket_id,FROM_UNIXTIME(uploaded) created_at created FROM traq_attachments;

-- Components INSERT INTO traq3_components (id,name,project_id) SELECT id,name,project_id FROM traq_components;

-- Custom Fields INSERT INTO traq3_custom_fields (id,name,code,project_ids) SELECT id,name,code,project_ids FROM traq_custom_fields;

-- Milestones INSERT INTO traq3_milestones (id,name,slug,codename,info,changelog,due,is_locked,project_id,displayorder) SELECT id,milestone name,slug,codename,info,changelog,due,locked is_locked,project_id,displayorder FROM traq_milestones;

-- priorities INSERT INTO traq3_priorities (id,name) SELECT id,name FROM traq_priorities;

-- projects INSERT INTO traq3_projects (id,name,slug,codename,info,next_tid,displayorder) SELECT id,name,slug,codename,info,next_tid,displayorder FROM traq_projects;

-- severities INSERT INTO traq3_severities (id,name) SELECT id,name FROM traq_severities;

-- statuses INSERT INTO traq3_statuses (id,name,status,changelog) SELECT id,name,status,changelog FROM traq_ticket_status;

-- subscriptions INSERT INTO traq3_subscriptions (id,type,user_id,project_id,data) SELECT id,type,user_id,project_id,data FROM traq_subscriptions;

-- tickets INSERT INTO traq3_tickets (id,ticket_id,summary,body,user_id,project_id,milestone_id,version_id,component_id,type_id,status_id,priority_id,severity_id,assigned_to_id,is_closed,is_private,created_at,updated_at,extra) SELECT id,ticket_id,summary,body,user_id,project_id,milestone_id,version_id,component_id,type type_id,status status_id,priority priority_id,severity severity_id,assigned_to,closed is_closed,private is_private,from_unixtime(created) created_at,from_unixtime(updated),'' updated_at FROM traq_tickets;

-- ticket_history INSERT INTO traq3_ticket_history (id,user_id,ticket_id,changes,comment,created_at) SELECT id,user_id,ticket_id,changes,comment,from_unixtime(timestamp) created_at FROM traq_ticket_history;

-- timeline INSERT INTO traq3_timeline (id,project_id,owner_id,action,data,user_id,created_at) SELECT id,project_id,owner_id,action,data,user_id,from_unixtime(timestamp) created_at FROM traq_timeline;

-- types INSERT INTO traq3_types (id,name,bullet,changelog,template) SELECT id,name,bullet,changelog,template FROM traq_ticket_types;

-- wiki INSERT INTO traq3_wiki (id,project_id,title,slug,body,main) SELECT id,project_id,title,slug,body,main FROM traq_wiki;

-- usergroups INSERT INTO traq3_usergroups (id,name,is_admin) SELECT id,name,is_admin FROM traq_usergroups; [/code]

4 years and 8 months ago by Jack

  • Changed Status from New to Started

4 years and 8 months ago by Jack

  • Closed ticket as Completed