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

  $ provendb-sqlserver install

  -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:

configStringIf specified, a configuration file for the newly installed provendb configuration will be created
createDemoAccountNoneIf specified a provendbdemo account will be created with sample tables
dropExistingNoneIf specified, existing user accounts will be dropped if they already exist
dbaPasswordStringPassword for the account used to install
dbaUserNameStringName of the account used to install
provenDBPasswordStringPassword for the newly created ProvenDB account
provendbUserStringUsername for the new ProvenDB account
sqlConnectStringSQL 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 

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