Migration-script

Instructions:

  1. Download and customize create_itracker_mig_and_transform.sh
  2. Download to the same directory: itracker_migration_transform_script.sql
  3. Download to the same directory: itracker_migration_new_indexes.sql
  4. Stop any running itracker-instances pointing to the new database, if appropriate.
  5. Execute the migration-script: $ ./mysql/create_itracker_mig_and_transform.sh [<password>]
  6. Start itracker3 configured to the migrated database
  7. Log-in to itracker3 using your previous 2.4 credentials

Customize transformation

Variables which can be set:

  1. DBUSER: Username for connecting Database.
  2. DBPASS: Will be passed as an argument to the execution-call.
  3. DATABASE: Name of 2.4 source-database to transform.
  4. DBTARGET: Name of the new migrated database.
  5. DBHOST: Hostname of mysql-server.

DDL Transformation script

CREATE TABLE issuerelationbean (
  id                    INT      NOT NULL auto_increment,
  issue_id              INT,
  rel_issue_id          INT,
  relation_type         INT,
  matching_relation_id  INT,
  create_date           DATETIME,
  last_modified         DATETIME,
  PRIMARY KEY(id)
) DEFAULT CHARACTER SET utf8;

CREATE TABLE workflowscriptbean (
  id                    INT       NOT NULL auto_increment,
  script_name           VARCHAR(255),
  event_type            INT,
  script_data           TEXT,
  create_date           DATETIME,
  last_modified         DATETIME,
  PRIMARY KEY(id)
) DEFAULT CHARACTER SET utf8;

CREATE TABLE projectscriptbean (
  id                    INT       NOT NULL auto_increment,
  project_id            INT,
  field_id              INT,
  script_id             INT,
  script_priority       INT,
  create_date           DATETIME,
  last_modified         DATETIME,
  PRIMARY KEY(id)
) DEFAULT CHARACTER SET utf8;

alter table languagebean change id id INT NOT NULL AUTO_INCREMENT; 

alter table configurationbean change id id INT NOT NULL AUTO_INCREMENT; 

alter table issuehistorybean change id id INT NOT NULL AUTO_INCREMENT;

alter table issuebean change id id INT NOT NULL AUTO_INCREMENT;

alter table versionbean change id id INT NOT NULL AUTO_INCREMENT;
UPDATE versionbean SET status = 1 WHERE status IS NULL;
alter table versionbean change status status INT NOT NULL;

alter table userpreferencesbean change id id INT NOT NULL AUTO_INCREMENT;
ALTER TABLE userpreferencesbean ADD use_text_actions INT NOT NULL AFTER remember_last_search ;

alter table userbean change id id INT NOT NULL AUTO_INCREMENT;

DELETE  FROM scheduledtaskbean; 
alter table scheduledtaskbean change id id INT NOT NULL AUTO_INCREMENT;

alter table projectbean change id id INT NOT NULL AUTO_INCREMENT;

alter table permissionbean change id id INT NOT NULL AUTO_INCREMENT;

alter table notificationbean change id id INT NOT NULL AUTO_INCREMENT;

alter table issuefieldbean change id id INT NOT NULL AUTO_INCREMENT;

alter table issueattachmentbean change id id INT NOT NULL AUTO_INCREMENT;

DELETE  FROM issueattachmentbean WHERE orig_file_name IS NULL;
alter table issueattachmentbean CHANGE issue_id issue_id INT NOT NULL;
alter table issueattachmentbean CHANGE orig_file_name orig_file_name VARCHAR(255) NOT NULL;
alter table issueattachmentbean CHANGE description description VARCHAR(255) NOT NULL;

alter table issueactivitybean change id id INT NOT NULL AUTO_INCREMENT;

alter table customfieldvaluebean change id id INT NOT NULL AUTO_INCREMENT;

alter table customfieldbean change id id INT NOT NULL AUTO_INCREMENT;

alter table componentbean change id id INT NOT NULL AUTO_INCREM
UPDATE componentbean SET status = 1 WHERE status IS NULL;
alter table componentbean change status status INT NOT NULL;

Older versions

Check old docs how to upgrade from previous itracker:

CHANGELOG itracker 2.4

INSTALL itracker 2.4

R.Ø.S.A.