nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

TM4J Data Migration During Jira Consolidation

Jay Kantaria

We are in process of consolidating a instance of Jira software into Jira Data Center.

This original instance uses Test Management for Jira plugin to manage their tests and test cycles.

During feasibility phase discovered that there is no real path to migrate all of the TM4J data from one instance to another. Adaptivist confirmed that currently only test cases can be exported and imported to another instance.

We would like to preserve the test plans, cycles, attachments and all of the associated data for the compliance and other reasons.

Are there nay good migration paths people have achieved this? Any related help will be greatly appreciated. I know I can't be the first to come across this challenge.

Thank you for your help.

Accepted answers

All comments

Jeff Turner_kz2hhu

TM4J uses the ActiveObjects library, and at least since Jira 7.0 the AO data has been included in project exports, so what's the problem?

At any rate, if the TM4J data is in the database, it could be transferred to the new instance with SQL. I like to do this by importing the tables into a separate database schema, and then using SQL to copy from one schema to the 'public' schema tables. Myself or any Atlassian partner (incl. Adaptavist) should be able to help with that.

Jay Kantaria

Thanks Jeff - It does not look like it is simple to transfer all of the data. There is definitely path forward for test cases export/import.

I had meeting with Adaptivist and they wanted consulting engagement. I asked for data mapping/structure all of their table and sample scripts.

Do you have names of the table this information is stored?

Thanks,

Jay

Jeff Turner_kz2hhu

No, but if you look in your database you should see AO_* tables, all with the same number prefix, that belong to the plugin. Table names correspond to the ao config in the plugin jar's atlassian-plugin.xml file:

 <ao key="ktm-ao-config" name="Active Objects Configuration" namespace="com.kanoah.test-manager">
<entity>com.kanoah.testmanager.model.activeobjects.FolderEntity</entity>
<entity>com.kanoah.testmanager.model.activeobjects.TestCaseEntity</entity>
<entity>com.kanoah.testmanager.model.activeobjects.TestScriptEntity</entity>
<entity>com.kanoah.testmanager.model.activeobjects.PlainTextScriptEntity</entity>
...

so look for AO_*_TESTCASEENTITY or similar.

jvl_share

We came to this situation lately too -- migrated our JIRA from one server to another, so now struggling with the problem that the screenshots in our test cases and test runs are lost.

The image url still pointing to the old server.

Our test cases, test cycles and test runs text data are okay.

Given that TM4J is the top rated test plugin for JIRA, quite surprised/disappointed that it is not capable to migrate data completely.

Tobias Meyer_o703c0

Hi All..

We had similar problems merging TM4J data from one instance to another. We finally created a parametrised job to copy all zephyr data to the new instance.

Check out our blog for further details: https://kreuzwerker.ch/post/jira-merge-and-beyond

There you can find all the steps needed. You can try to perform it yourselves or we would love to support you.

Best regards

Tobias

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

migration

jira-software

jira-software-server

tm4j

consolidate