MES Database Setup component properties

Database Server, Name, and Authentication

• MES.FactDB.ServerName

  The name of the server that is hosting the MES database.

  If this property is not specified, the server name defaults to the local server.

  Supported server names include IP addresses (IPv4 and IPv6 addressing is supported), SQL server named instance conventions, and cluster names.

• MES.FactDB.DatabaseName

  The name of the MES database. If this property is not specified, the name defaults to MESDB.

• MES.FactDB.UseIntegratedSecurity

  Values are:

  • True: Use Windows Integrated Security. The currently logged-in Windows user account will be used to access SQL Server. No user name or password has to be specified in the response file.

  • False: Use SQL Server Authentication. Specify the appropriate SQL Server Authentication user name and password with the UserName and DatabasePassword properties.

    When False, the UseIntegratedSecurity property must always precede the UserName and DatabasePassword properties. Otherwise, the False setting of this property will cause the values of the UserName and DatabasePassword properties to be cleared.

    The default value True is used if this property is not specified.

• MES.FactDB.UserName

  If SQL Server Authentication is being used, the SQL user name.

• MES.FactDB.DatabasePassword

  If SQL Server Authentication is being used, the SQL user password.

Advanced Properties

These properties are optional and apply only to new MES databases.

• MES.FactDB.DataFilePath

  The file path of the data file. See the installed version of SQL Server for the default data file path that is used if this property is not specified.

• MES.FactDB.DataFileSize

  The initial size, in MB, of the data file. The default value 30 is used if this property is not specified.

• MES.FactDB.DataFilePercentGrowth

  The percent by which to limit the percent growth of the data file. The default value 10 is used if this property is not specified.

• MES.FactDB.LogFilePath

  The file path of the log file. See the installed version of SQL Server for the default log file path that is used if this property is not specified.

• MES.FactDB.LogFileSize

  The initial size, in MB, of the log file. The default value 30 is used if this property is not specified.

• MES.FactDB.LogFilePercentGrowth

  The percent by which to limit the percent growth of the log file. The default value 10 is used if this property is not specified.

Upgrading Properties

These properties apply only when upgrading to a new version of MES.

• MES.FactDB.Overwrite

  Values are:

  • True: If the MigrateData property is set to True, migrate the existing MES database to the new release.

    If the MigrateData property is set to False, overwrite the existing database with a new MES database.

  • False: Keep the existing MES database with no changes. You might use this setting in case, for example, the named MES database already exists but was not expected to be there. The database would not be overwritten, but the upgraded MES would not be usable until a new MES database was created or the existing one was migrated.

    The default value True is used if this property is not specified.

• MES.FactDB.MigrateData

  Values are:

  • True: If the MES.FactDB.Overwrite property is True, migrate the existing MES database to the new release.

  • False: If the MES.FactDB.Overwrite property is True, overwrite the existing database with a new MES database.

    The default value True is used if this property is not specified.

• MES.FactDB.AggregateItemProduction

  Applies only if the Overwrite and MigrateData properties are set to True. Values are:

  • True: If the existing MES database that you are migrating has the system parameters for recording distinct production records set, aggregate these records are aggregated into hourly records and distinct production records are disabled.

  • False: Do not aggregate distinct production records.

    The default value True is used if this property is not specified.

    It is recommended to aggregate production records into hourly buckets, as this will improve the overall system performance for recording production and reporting on production data. In versions prior to MES version 4.5, recording distinct production records was required for reporting hourly KPIs, but this is no longer the case. You might still want distinct production records for other reasons, in which case set this property to False.