NI TestStand

cancel
Showing results for 
Search instead for 
Did you mean: 

SQL file to create 2016 default schema

Solved!
Go to solution

Is there a provided SQL file to create the tables and columns for the TestStand 2016 default schema? I have not been able to find one.

I want to create an SQL file to add the columns to the tables with the changes from 2013.

 

Stephen

0 Kudos
Message 1 of 3
(2,786 Views)
Solution
Accepted by topic author stephenb2

I found "MySQL Create Insert Result Tables.sql" in:

 

C:\Program Files (x86)\National Instruments\TestStand 2016\Components\Models\TestStandModels\Database

0 Kudos
Message 2 of 3
(2,769 Views)

So it looks like the following should convert a MySQL database for TestStand 2013 to version 2016.

 

ALTER TABLE PROP_NUMERICLIMIT ADD THRESHOLD_TYPE VARCHAR(32);
ALTER TABLE PROP_NUMERICLIMIT ADD NOMINAL_VALUE DOUBLE;
ALTER TABLE PROP_NUMERICLIMIT ADD UPPER_THRESHOLD DOUBLE;
ALTER TABLE PROP_NUMERICLIMIT ADD LOWER_THRESHOLD DOUBLE;
0 Kudos
Message 3 of 3
(2,766 Views)