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.
|
|
#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. |
This variable is determined through the code. We recommend that you do not hard code
this variable.
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.
|
|
#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. |