SQLite Database Files
An SQLite project contains the following database files under WinCC_OA_Proj/db/wincc_oa/sqlite. You can view them via a database viewer such as sqlitebrowser :.
Database File | Description |
---|---|
config.sqlite | Contains the config file of the project that is automatically created. Further configuration is not required. |
ident.sqlite | Contains datapoints and datapoint IDs. |
last_alert.sqlite | Contains the current alerts of the project. |
last_value.sqlite | Contains the current values of the project. |
Note: In case of a power loss of a project, a startup repair is no longer required. The database is not corrupted by a power failure and the project can therefore
always be started successfully.
Database Tools
In the same way as, for example, the WCCOAtoolCreateDb tool is available for the RAIMA database, tools for SQLite are available in the: wincc_oa_path/bin directory. For example, WCCOAtoolCreateDbSQLite.exe. For how to create a project by using the tool, see chapter Creating multilingual projects.