Collections:
Truncate Test Case and Test Run Tables
How to Truncate Test Case and Test Run Tables? I want to remove old data and start it over from empty tables.
✍: FYIcenter.com
You can follow this tutorials to truncate Test Case and Test Run Tables.
1. Create a SQL script file, TruncateTestMan.sql:
-- TruncateTestMan.sql use TestMan; truncate table Test_Run_Case_Step_Input; truncate table Test_Run_Case_Step_Assertion; truncate table Test_Run_Case_Step; truncate table Test_Run_Case_Parameter; truncate table Test_Run_Case; truncate table Test_Run; truncate table Test_Case_Step_Input; truncate table Test_Case_Step_Assertion; truncate table Test_Case_Step; truncate table Test_Case_Reference; truncate table Test_Case_History; truncate table Test_Case_Parameter; truncate table Test_Case;
2. Run TruncateTestMan.sql:
>\fyicenter\mysql\bin\mysql -u fyicenter < TruncateTestMan.sql
⇒ Generating Reports from TestMan Database
⇐ Archive JMeter Test Result Data
2017-11-26, 2177🔥, 0💬
Popular Posts:
How to expand IPv6 addresses? In order to help your programming or testing tasks, FYIcenter.com has ...
What are date and time test values? Date and time test values are frequently needed in testing date ...
How to turn off HTTP response compression in SoapUI? HTTP response compression reduces the data size...
How to validate domain name format? In order to help your programming or testing tasks, FYIcenter.co...
Where to find tutorials on Test Management? I want to know how to manage software testing documents ...