MS SQL® Server Installation - DB Parameters
| Parameter | Description |
|---|---|
| -h, --dbServer | Specifies the server name. (Default value: .\MSSQLSERVER) |
| -p, --port | - Specifies the TCP port. (Default value: 1433) |
| -U, --adminUsername | Connect to the database as the adminstrator user. (Default value: sa) |
| -d, --dbName | Specifies the name of the database to connect to. (Default value: winccoa) |
| -P, -- adminPassword | Connect to the database with the administrator user password. (Default value: Qwe12345) |
| -s, --sqlscriprtpath | Specifies the path to the shema.sql script. (Default value: schema.sql.) |
| -u, --useNumericForStoringFloatValues | By default "DOUBLE PRECISION" DB column-type will be used for storing float values. Use this flag in case you need to use NUMERIC column-type for storing large numeric values |
| -f, --dbPath - Location | Location in the file system where the files representing database objects are stored. (Default value: D:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA) |
| -b, --dbBackupPath | Location in the file system where the files representing backup database objects are stored. (Defaul value: d:\mssql\backups) |
| -wu, --winccoaUsername | Connect to the database as the user. (Default value: winccoa) |
| -wp, --winccoaPassword | Connect to the database with the user password. (Default value: winc-coa) |
| -dis, --dbInitSize | Specifies the initial size of the data file. (Default value: 8MB) |
| -dfg, --dbFileGrowth | Specifies the automatic growth increment of the data file. (Default value: 64MB) |
| -lis, --logInitSize | Specifies the initial size of the log file. (Default value: 8MB) |
| -lfg, --logFileGrowth | Specifies the automatic growth increment of the log file. (Default value: 64MB) |
| -lmx, --logMaxSize | Specifies the maximum size to which the log file can grow. (Default value: 2097152MB) |
Note:
The backup folder must be accessible for users under which the WinCC OA is running.
