Import Data into TestStand 2.0 Schema

[Dennis_Knutson]

Has anyone created a tool (sequence, stored procedure, etc.) for importing data from a TestStand 1.0.2 database schema into a TestStand 2.0 database schema? I'm using SQL Server 2000. Thanks in advance.

[rpfi]

Hello Dennis,

Unfortunately there is no tool for importing data from TestStand 1.0.2 database tables (DB Schemas) into TestStand 2.0 tables. However, you can manually create SQL scripts to copy/move data from the old table structure to the new ones. Also, you can still use the TS 1.X schema in TS 2.0 (Under Configure->Database Options->Schemas you can select TS 1.X Access/SQL (NI) as your default schema.)

Roberto Piacentini
National Instruments
Applications Engineer
www.ni.com/ask