SQL Server template files - SmartPlant Foundation - Administration

SmartPlant Foundation Server Manager Help

PPMProductFamily
Asset Information Management
PPMProduct
SmartPlant Foundation
PPMCategory
Administration
SPFVersion_custom
2019 (10.0)
Version_MTR
(none)

The following script files are used for SQL Server operations. The tables below list the variables for each script file.

Template_CreateDBSQL.sql

This template is used to create the database. This will create the MDF and the LDF files for the SQL Server Data database.

Variable

Description

#DATA_DB#

Name of the Data database to be created.

Template_CreateLoginSQL.sql

This template is used to create the SQL Server logins.

Variable

Description

#DATA_USER#

Name of the Data user entered.

#DATA_PWD#

Password entered for the Data user.

#DATA_DB#

Name of the Data database to be created.

Template_ImportDumpSQL.sql

This template is used to import the dump files into the Data database.

Variable

Description

#DATA_DB#

Name of the Data database to be created.

#DATA_DUMP#

Path to the Data dump file.

#FROM_USER#

Variable from the database user who created the Data dump file.

This variable is determined through the code. We recommend that you do not hard code this variable.

#DATA_USER#

Name of the Data user entered.

#DEFAULT_PATH#

The default path of where the LDF and MDF files will be created. This value is retrieved from the SQL Server database.

Template_NewSiteSQL.bat

This batch file is used to login into SQL Server and to execute the following script files: CreateDBSQL, CreateLoginSQL, and ImportDumpSQL.

Variable

Description

#SYS_USER#

System user name for the SQL Server database. This is typically sa.

#SYS_PASS#

System password for the SQL Server database.

#DATASOURCE#

SQL Server data source\alias of the SQL Server database.

Template_ImportSQL.sql

This file is used to import a dump file into a SQL Server database in which the database and the user already exist.

Variable

Description

#USER_ID#

Name of the user ID for the connection string retrieved from the global.asa file for that site.

#DUMP_FILE#

This variable is the path to the dump file.

#FROM_USER#

Variable from the database user who created the SQL Server dump file.

This variable is determined through the code. We recommend that you do not hard code this variable.

#MDF_PATH#

The fully qualified path to the MDF file that will have the dump file imported into.

#LDF_PATH#

The fully qualified path to the LDF file that will have the dump file imported into.

Template_ImportSQL.bat

This batch file is used to login into the SQL Server database and to execute the ImportSQL file to import a dump file either into the Data database.

Variable

Description

#SYS_USER#

System user name for the SQL Server database. This is typically sa.

#SYS_PWD#

System administrator login password (the sa password).

#DATASOURCE#

Data source\alias of the SQL Server database. This value is taken from the global.asa connection string for the Data database, depending on which database is receiving the dump file.