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.
For SQLite® Online backup, see DB & Project Files Tabs.
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.
