I need to perform below activities in OpenHistorian SQL scripts.
- We are using SQL lite
- Need to add a new field “xName” in Pharsor at OpenHistorian.db
In order to perform this, I add new field at openHistorian.sql file and this file is present at OpenHistorian Installation location “C:\Program Files\openHistorian\Database Scripts\SQLite”
- I deleted existing “OpenHistorian.db” file
- Run the “ConfigurationSetupUtility.exe” file and reconfigured the database, but the new field is not added with Phasor table.
Also I want to add new sample data with Vendor table, for that I added new insert statement at “InitialDataSet.sql”, but my new record is not added in the vendor table.
Could you please clarify, why new field and new records are not getting updated?
Is there any other file to update before running “ConfigurationSetupUtility.exe”?
Thanks & Regards