Deploying a new Database Schema to a Test System?

[ShaneDonn]

Hi,

I have created a new MYSQL schema (on a development machine) that I would like to deploy to a number of test systems.

What is the easiest way to do this? Is there a file somewhere in the TestStand Directory that I can copy over?

Thanks & Regards,

Don1.

[Dennis_Knutson]

The schema of your database will not be defined anywhere in TestStand. It's what you created in MySQL. I have not used MySQL but you should investigate the tools in there to generate a script that will create the tables. Similar to the .sql files in the Database folder that create one of the standard schemas. If you used one of these as a starting point, then you can add/modify the sql statements in there.

[ShaneDonn]

Hi Dennids

I have the Schema and database already created on my development machine.

What I am wondering is what is the easiest way to port this new Schema In TestStand I have created (in Configure > Database Options> Schema > MYSQL Insert New) to a test machine? Do I just create a new Installer using the TestStand Deployment Tool?

Thanks & Regards,

Don1.

[Dennis_Knutson · Accepted solution]

I don't think you are using the definition of schema correctly. The schema applies only to the database. The schema does not exist in TestStand and you do not port the schema anyplace unless you want to install a new database somewhere. The database options for writing/reading a particular database schema are saved in the TestStandDatabaseOptions.ini file and you can choose to include this in a deployment.

[James_Grey]

TestStand reuses that term, due to lack of a better word.

In the database options dialog, there is a Schemas tab. In this context, the word 'Schema' mean a definition of how to map TestStand results to a particular set of database tables (that follow their own schema in the traditional sense of the word).

I think you are correct as to where the 'TestStand Schemas' are stored.

Message Edited by James Grey on 03-31-2009 10:41 AM

[ShaneDonn]

Hi Dennis,

Thanks for all the help,

You were correct in the file to deploy

FYI:http://digital.ni.com/public.nsf/allkb/D68E8C9997CE861786256E62005B02F4

Regards,

Don1.

[Dennis_Knutson]

I've just never associated that tab with anything but the database schemas in the 'traditional sense of the word' since it allows you to choose a particular database schema.