ProvenDB for SQLServer installation

Once you've downloaded the ProvenDB for SQL Server binary, you should install the provendb user and internal tables using the provendb-sqlserver install command. This command has the following usage:

✗ provendb-sqlserver install --help
Installs the ProvenDB for SQL Server users and tables

USAGE
  $ provendb-sqlserver install

OPTIONS
  -v, --verbose                        increased logging verbosity
  --config=config                      Create config file
  --createDemoAccount                  Create the ProvenDB Demo account
  --dbaPassword=dbaPassword            DBA Password
  --dbaUserName=dbaUserName            [default: SA] DBA Username
  --dropExisting                       Drop existing users if they exist
  --provendbPassword=provendbPassword  (required) ProvenDB User Password
  --provendbUser=provendbUser          [default: provendb] ProvenDB User Name (defaut: provendb)
  --sqlConnect=sqlConnect              (required) [default: Server=localhost,1433;Encrypt=false] SQL Server connection String

The installer takes the following arguments:

Argument

Type

Description

config

String

If specified, a configuration file for the newly installed provendb configuration will be created

createDemoAccount

None

If specified a provendbdemo account will be created with sample tables

dropExisting

None

If specified, existing user accounts will be dropped if they already exist

dbaPassword

String

Password for the account used to install

dbaUserName

String

Name of the account used to install

provenDBPassword

String

Password for the newly created ProvenDB account

provendbUser

String

Username for the new ProvenDB account

sqlConnect

String

SQL Server connection string

Here's a sample installation on a local SQLEXPRESS database:

C:\Users\gharriso\git\provendb-sqlserver>provendb-sqlserver install --config=myConfig.yaml 
--dbaPassword=xxxxx --dbaUserName=SA --provendbPassword=mySecretPassword123 
--provendbUser=guy 
--sqlConnect="Server=localhost\SQLEXPRESS;1433;Encrypt=false;Trusted_Connection=True;TrustServerCertificate=True"

15:24:20.857 INFO  Connecting to SQL Server
15:24:20.982 INFO  Dropping user and objects for guy
15:24:21.295 INFO  Creating user and schema
15:24:21.592 INFO  Creating tables and procedures
15:24:21.654 INFO  Wrote new config to myConfig.yaml
15:24:21.654 INFO  This configuration uses a trial key - get your key at https://app.provendb.com/app/dashboard/api-keys
15:24:21.654 INFO  Install complete

🚧

If you auto-generated a configuration file, then a trial key will be inserted into the file. To use your own key you will need to add your API key to the configuration file.