For SQL servers, the tablespaces described in the chapter on Tablespaces are configured as follows:
Example: SQL Server 2017
Tablespace name |
Key |
---|---|
Default |
SQLSERVER_2017_TBLCONF_STDTABLE |
Binary data |
SQLSERVER_2017_TBLCONF_STDBLOB |
Indices |
SQLSERVER_2017_TBLCONF_STDINDEX |
The tablespace is specified by the following syntax:
Key = ON <Tablespace name>
Example
File extract Database_settings.properties
SQLSERVER_2017_TBLCONF_STDTABLE=ON PPMDATA
SQLSERVER_2017_TBLCONF_STDINDEX=ON PPMINDX
SQLSERVER_2017_TBLCONF_STDBLOB=ON PPMBLOB