Write to TestStand DataBase

[LuisMontoya]

Hi guys!

I'm using test stand and saving all data into the standar Database (access),

but I have others testers than I'm using just LabView (no TestStand Installed) and I would like save all test data into the TestStand dataBase, is any way to do that?

I'm not a DataBase expert, I just have basic knowledge, but I did a DataBase query some months ago, you can find find it here 

https://forums.ni.com/t5/NI-TestStand/TestStand-DataBase-Query/m-p/2866064

do any body make the oposite? save all data into TestStand Database using SQL commands?

Thank you.

knowledge

[Shalini.M]

Hi LuisMontoya, 

In case you haven't already seen these, here are some relevant tutorials and documents: 
Getting Started Logging to Databases Quickly with NI TestStand
Logging TestStand Results to a MySQL Database

Database Viewer Application

If you don't have TestStand Installed on a computer, you won't be able to save data into the TestStand dataBase. However, you can use one of the database connectivity systems that TestStand communicates with like Oracle, SQL Server, MySQL, or a Microsoft Access database.

Regarding the opposite, this tutorial might be relevant:
Creating a TestStand Database Schema from Scratch

[LuisMontoya]

Thank you Shalumdawg,

but yes I saw that links already but have no information about what I need to do.

I need something like this:

insert into UUT_RESULT ("PartNumber"....... )

values (" "," ",......)

the way as TestStand is sending all data into database.

[mkossmann]

Did you see  <TestStand Installation Directory>/Components/Models/TeststandModels/Database ? This might give you some ideas. how Teststand does the database access.

[LuisMontoya]

Yes I did Mkossman,

there are "Schemas" to get results only, NOT to insert test results.

but thank you, I will continue trying.