|
If you are not using Linux, go to the section, MSSQL Database Setup for ThingWorx: Windows.
|
|
Software downloads are available on the PTC eSupport page.
|
Option
|
Parameter
|
Default
|
Description
|
Example
|
---|---|---|---|---|
-h
|
server
|
localhost
|
FQDN or IP of database server
|
-h 10.0.0.221
|
-i
|
server-instance
|
<blank>
|
Instance name provided during database installation
|
-i SQLEXPRESS
|
-p
|
port
|
1433
|
Port of SQL Server
|
-p 1433
|
-a
|
database-admin-user-name
|
sa
|
Admin user name which is having appropriate rights.
|
-a sa
|
-r
|
password
|
Password@123
|
Password of database-admin-user
|
Password@123
|
-l
|
login-name
|
twadmin
|
Name of login created above manually.
|
-l twadmin
|
-d
|
thingworx-database-name
|
thingworx
|
Name of database
|
-d thingworx
|
-u
|
thingworx-user-name
|
<same-as-login-name>
|
Name of user which will be created inside the database
|
-u twadmin
|
-s
|
schema-name
|
twschema
|
Name of schema created inside thingworx database.
|
-s twschema
|
Option
|
Parameter
|
Default
|
Description
|
Example
|
---|---|---|---|---|
-h
|
server
|
localhost
|
FQDN or IP of database server
|
-h 10.0.0.221
|
-i
|
server-instance
|
<blank>
|
Instance name provided during database installation
|
-i SQLEXPRESS
|
-p
|
port
|
1433
|
Port of SQL Server
|
-p 1433
|
-l
|
login-name
|
twadmin
|
Name of login created above manually.
|
-l twadmin
|
-r
|
password
|
Password@123
|
Password of database-admin-user
|
Password@123
|
-d
|
thingworx-database-name
|
thingworx
|
Name of database
|
-d thingworx
|
-o
|
option
|
all
|
To execute all scripts. Model, data, property, and model with properties will execute.
|
-o all
|
Option
|
Parameter
|
Default
|
Description
|
Example
|
---|---|---|---|---|
-h
|
server
|
localhost
|
FQDN or IP of database server
|
-h 10.0.0.221
|
-i
|
server-instance
|
<blank>
|
Instance name provided during database installation
|
-i SQLEXPRESS
|
-p
|
port
|
1433
|
Port of SQL Server
|
-p 1433
|
-a
|
database-admin-user-name
|
sa
|
Admin user name which is having appropriate rights.
|
-a sa
|
-r
|
password
|
Password@123
|
Password of database-admin-user
|
Password@123
|
-d
|
thingworx-database-name
|
thingworx
|
Name of database
|
-d thingworx
|