Test 2.0 - how to migrate test steps/versions between environments?

[SandyL83]

Hello,

We setup Test 2.0 in our Test environment recently and now we need to either migrate it Production or find a way back up all of the data so when we clone Test, it's not all blown away. 

Can someone please give advice?

I was able to get the xml for the following tables:

sn_test_management_test_execution_suite
sn_test_management_test
sn_test_management_test_assignment

sn_test_management_test_version

However, on the Test Version, that is where they are add the Test Steps,  so in this scenario, when I upload all of these xmls to a different environment, it's missing the test step, and I am not able to find a way to get any back up of that. 

Does anyone have any solutions or suggestions?

Thank you!

[Bert_c1 · Accepted solution]

See:

https://[instance].service-now.com/sys_db_object_list.do?sysparm_query=GOTOnameSTARTSWITHsn_test_man...

for a list of related tables.

[reshmapatil]

Hi @SandyL83 ,

Check the 'Test Steps[sys_atf_step]' table to get Test Steps.

As the test steps are captured in Test Step table we have to export xml of steps separately.

Regards,

Reshma

**Please mark my answer correct or helpful based on the impact**

[SandyL83]

Hi, thanks  for the feedback. This is actually Test 2.0, not ATF, so it's manual test still.  I am attaching a screenshot for you to  see the test version that has the steps on it.  Any other ideas?

[Bert_c1 · Accepted solution]

See:

https://[instance].service-now.com/sys_db_object_list.do?sysparm_query=GOTOnameSTARTSWITHsn_test_man...

for a list of related tables.

[Bert_c1]

More useful, replace "[instance]" with your instance:

https://[instance].service-now.com/sys_db_object_list.do?sysparm_query=GOTOnameSTARTSWITHsn_test_management&sysparm_view=