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.

[Tobias Meyer]

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

[Jeff Turner]

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]

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.

[PA Admin]

We had a similar issue and agree with TM4J being a top-rated plugin, it clearly needs some improvements.

We imported some test cases and because our spreadsheet wasn't formatted correctly, they got imported incorrectly and because we couldn't delete them, had to archive them. This meant the new test case id's started in mid-hundreds. We decide to delete the test cases from AO_Test cases table in the database which somewhat resolved the issue. I wouldn't recommend though. Hopefully, if they can introduce the Delete functionality that would be good. 

[Peter Wells]

Which raises the question: why is delete no longer available as an option?

[PA Admin]

I'm told it is coming back. They have an issue raised for it and a lot of people are demanding it back. So hopefully soon in a future release.

[Theodore Carraher]

Does Zephyr Scale running in Jira Cloud store data in ActiveObjects SQL within Jira? Or is it stored on SmartBear servers?