How do I write data from citadel to mysql programmatically in Labview?

[mearleywine1]

I would like to use labview commands to set up the mySQL database to receive the data that I have historically written and am currently writing to citadel.  Ideally, the structure of the sql database will be based on the structure of the data in the citadel database.  What is the best way to do this?  Thanks for your help!

[KateB]

You need to use database connectivity toolkit to write data to MySQL. Just use a VI to insert new record to database. You would need to have a field for timestamp and data itself to replicate Citadel.

[Yamaeda]

If you set up the tables in the same way and are already using database toolkit and connect through UDLs, then you should only need a new UDL. 🙂

Both databases should react to SQL in the same way.

/Y