Running the State Store database creation script

You can use a PowerShell script to create a Microsoft SQL Server or Oracle database from a Windows system.

About this task

Procedure

  1. On a system that meets the prerequisites for database installation and upgrade scripts, open PowerShell.
  2. In PowerShell, depending on your database navigate to one of the following folders on the installation media:
    • For a Microsoft SQL Server, AWS RDS-MSSQL or Microsoft Azure database, navigate to Database\MSSQL\
    • For an Oracle database, navigate to Database\Oracle\
  3. Type the following command:
    & '.\Install Deployer State Store.ps1'
  4. Answer Yes if you are installing an AWS RDS-MSSQL 2016 database and you see the following prompt:
    This database server version is not supported. Supported database server versions are 'Microsoft SQL Server 2016 SP2',
    'Microsoft SQL Server 2017'. Do you want to continue anyway?

Results

You have created the State Store database.