Database Installer¶
The Qualtrak Coach Database Installer.
Usage¶
Note
Use config.db.ps1
to set up Coach Database Installer to meet desired needs.
Get Help for Qualtrak Coach Databse Installer Cmdlet
Install-CoachDb
Get-Help Install-CoachDb -Full Install-CoachDb -?
- Run
Install-CoachDb
to install Coach. See “Examples” for more info or usage.
Examples¶
Note
- See more info about
Install-CoachDb
parameters in “Parameters” section. - Please use single quotes (‘’) around parameter values, double quotes (“”) values evaluate as Powershell statement, so it can have undesired effect!
Minimal command with usage of required parameter
DbPasswd
. If omitted, user will be prompted to enter manually:Install-CoachDb -DbPasswd '$ecReT'
Full example with all parameters. Note that
-SysPasswd
is only needed for first-install of Coach:Install-CoachDb -DbSrv 'srv\ins' -DbUsr 'admin' -DbPasswd '$ecReT' -RecorderIP '10.0.0.1' -SysPasswd 'P@$$w0rd'
Parameters¶
Note
Please use single quotes (‘’) around parameter values, double quotes (“”) values evaluate as Powershell statement, so it can have undesired effect!
DbSrv¶
- Specifies the SQL Server database serverinstance.
- General default value can be changed in
config.db.ps1
for property$dbInstanceName
it is by default set to.\SQLEXPRESS
.
Note
DbSrv
parameter will always overrideconfig.db.ps1
property$dbInstanceName
!- If you want to use general default value use
config.db.ps1
property$dbInstanceName
, if it is changeable use thisDbSrv
Parameter.
DbUsr¶
- Specifies the SQL Server database serverinstance user login name.
- This value is not persisted or saved in any way, it is only for lifetime of installation session.
- General default value can be changed in
config.db.ps1
for property$dbLoginName
it is by default set to$null
.
Note
DbUsr
parameter will always overrideconfig.db.ps1
property$dbLoginName
!- If you want to use general default value use
config.db.ps1
property$dbLoginName
, if it is changeable use thisDbUsr
Parameter.
DbPasswd¶
- Specifies the SQL Server database serverinstance password.
- This value is not persisted or saved in any way, it is only for lifetime of installation session.
- Required.
Note
- If not specified will stop script and wait for
DbPasswd
enter manually in prompt! - If
DbPasswd
value is whitespace it will terminate the script!