Database Installer

The Qualtrak Coach Database Installer.

Description

The Qualtrak Coach Database Installer installs:

  • Coach Database.

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 override config.db.ps1 property $dbInstanceName!
  • If you want to use general default value use config.db.ps1 property $dbInstanceName, if it is changeable use this DbSrv 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 override config.db.ps1 property $dbLoginName!
  • If you want to use general default value use config.db.ps1 property $dbLoginName, if it is changeable use this DbUsr 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!