WCCOAtoolCreateDb

This program creates a new database based on the entries of the configuration file config.

The status indications and the error messages from WCCOAtoolCreateDb/WCCOAtoolCreateDbSQLite are written into the file createDb.log under the path <proj_path>/log/.

WCCOAtoolCreateDbSQLite

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.

The parameters of WCCOAtoolCreateDb / WCCOAtoolCreateDbSQLite are:
```
-config <proj_path>\config\config { -lang <lang> } 
-help -system <Systemnummer> <Systemname> -yes
```
If no system name is entered, then WCCOAtoolCreateDb / WCCOAtoolCreateDbSQLite will automatically add a name.
During a WinCC OA project creation it is possible to pass the data point lists (which are normally imported by the ASCII manager) directly to the WCCOAtoolCreateDb / WCCOAtoolCreateDbSQLite tool and consequently import them automatically.
```
-importAsciidplist/<File>
```
For <File> enter a data point list file. Per command line the import of only one file is allowed. The data point lists will be imported in this sequence they have been entered to the operating system command lines.
Either an absolute path or a relative path can be entered. In case of a relative path, the /dplist project folder will be browsed.

Enter e.g. the following commands to the command line:

WCCOAtoolCreateDB -system <otherOptions> 
-importAscii dplist/testFile1.txt
-importAscii dplist/testFile2.txt
-importAscii dplist/testFile3.txt

Command line options

-apar (ASCII manager),
-dpar (Data manager),
-epar (Event manager), 
-spar (Simulation manager)

If other data and event host names and port numbers are used than the default host names and ports, these host names and port numbers must be specified by using -apar, -dpar, -epar and -spar.

The following example shows how to create a database by using other port numbers than the default ports:

wincc_oa_path\bin>WCCOAtoolCreateDb 
-yes -config D:\WinCC_OA_Proj\DBCreateTest\config\config 
-lang en_US.utf8  -system 402 mySystem1 
-apar "-data localhost:5897 -event localhost:5998" 
-dpar "-data localhost:5897 -event localhost:5998" 
-epar "-data localhost:5897 -event localhost:5998" 
-spar "-data localhost:5897 -event localhost:5998"

Note:

Note that the host names and port numbers used for -dpar, -epar, -apar and -spar, MUST correspond to the host names and port numbers specified by using the "data" and event" config entries in the project config file.

data = "localhost:5897"

event = "localhost:5998"

When you create a database by using the WCCOAtoolCreateDb.exe tool, the languages are listed including the parameters

{Active}{Para}{Meta}:

{Active} is the "lang" entry of the config file,

{Meta} is the "metaLang" entry of the config file and

{Para} is an obsolete entry.