Column

Definition

SQLDataFilePath

PRODUCTION - Where you want data to be stored on the target SQL server - the actual path to the data file.  If left blank, the SQL server default will be used.

SQLLogFilePath

PRODUCTION - Where you want the log file to be stored on the target SQL server - the actual path to the log file.  If left blank, the SQL server default will be used.

SQLDataFilePathStaging

STAGING - Where you want data to be stored on the target SQL server - the actual path to the data file.  If left blank, the SQL server default will be used.

SQLDataLogPathStaging

STAGING - Where you want the log file to be stored on the target SQL server - the actual path to the log file.  If left blank, the SQL server default will be used.

ArchiveConnString

PRODUCTION - The encrypted query string, with a {%V1%} placeholder for the name of the database, to be used to connect to the target SQL server for archiving purposes.  The encryption is the ESI proprietary encryption.  Below is an example of where the variable placeholder goes:

.... ; initial catalog={%V1%}

The MIE will replace the {%V1%} with the name of the target database when forming the connection string.  The {%V1%} should be entered in the unencrypted connection string, and then encrypted with the rest of the template connection string.

NOTE:  This variable may be left blank (not recommended).  if left blank, the archive database will be created on the same SQL server as the production database, using the same connection string (meaning it will also use the same MIE user as production).

ArchiveConnStringStaging

STAGING - The encrypted query string, with a {%V1%} placeholder for the name of the database, to be used to connect to the target SQL server for archiving purposes.  The encryption is the ESI proprietary encryption.  Below is an example of where the variable placeholder goes:

.... ; initial catalog={%V1%}

The MIE will replace the {%V1%} with the name of the target database when forming the connection string.  The {%V1%} should be entered in the unencrypted connection string, and then encrypted with the rest of the template connection string.

NOTE:  This variable may be left blank (not recommended).  if left blank, the archive database will be created on the same SQL server as the staging database, using the same connection string (meaning it will also use the same MIE user as STAGING).