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.