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.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!

RecorderIP

  • Specifies the Recorder IP address with any valid IP Address or DNS name.
  • General default value can be changed in config.ps1 for property $recorderIpAddress it is by default set to localhost.

Note

  • If RecorderIP parameter will always override config.ps1 property $recorderIpAddress!
  • If you want to use general default value use config.ps1 property $recorderIpAddress, if it is changeable use this RecorderIP Parameter.