Example script: Microsoft SQL Server database on premises using create-db command
The following example shows planning for and creating a Spotfire database schema for a Microsoft SQL Server database in an on-premises Spotfire Server deployment.
Use the
following code template to plan and create a database schema with the command
create-db
.
See
Creating a Spotfire database using the command create-db
for instructions.
Microsoft SQL Server database on premises:
config create-db
--driver-class="com.microsoft.sqlserver.jdbc.SQLServerDriver"
--database-url="jdbc:sqlserver://{{database-host}}:{{database-port}}"
--admin-username="{{admin-user}}"
--admin-password="{{admin-password}}"
--spotfiredb-dbname="{{spotfire-database}}"
--spotfiredb-username="{{spotfiredb-user}}"
--spotfiredb-password="{{spotfiredb-password}}"
For each option shown in the above example,
replace the placeholder variable with your own value. The following example
shows example values to pass to the command
create-db
.
Option | Example value |
---|---|
--driver-class
|
"com.microsoft.sqlserver.jdbc.SQLServerDriver"
|
--database-url
|
"jdbc:sqlserver://myserver:5432"
|
--admin-username
|
"sa"
|
--admin-password
|
"system"
|
--spotfiredb-dbname
|
"spotfire_server"
|
--spotfiredb-username
|
"spotfire"
|
--spotfiredb-password
|
"admin"
|
In the following code, we have
replaced the template variables with the example values. The command is ready
to run to create the database schema. Your values will differ.
Note: This example has line breaks to make it easier to read the assigned
values. To use this example, you must copy it to a text editor, provide your
own values, and remove the line breaks first.
config create-db
--driver-class="com.microsoft.sqlserver.jdbc.SQLServerDriver"
--database-url="jdbc:sqlserver://myserver:5432"
--admin-username="sa"
--admin-password="system"
--spotfiredb-dbname="spotfire_server"
--spotfiredb-username="spotfire"
--spotfiredb-password="admin"
Parent topic: Examples for on-premises database deployments