Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

TM4J Data Migration During Jira Consolidation

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.

2 answers

0 votes
Jeff Turner Community Leader Nov 21, 2019

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.

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 Community Leader Nov 22, 2019

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.

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.

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. 

Like jvl_share likes this

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

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.

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

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

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Trello

🏊‍♀️ Atlympic Event: Trello

Hello Community!  Quick disclaimer: We are running a contest on Community (The Atlympics!) from July 23rd - August 8th of 2021. If you are interested in participating in this contest (prizes! ...

134 views 2 12
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you