Database Creation

The Database Configuration Utility allows you to create or modify the MES database as a stand-alone operation external to the MES Installation setup. This utility is executed after the Wonderware MES Software/Operations installation is completed.

You can use the Database Configuration Utility to:

• Create or modify the database on both SQL Server and Oracle.
• Dump the scripts on your local computer if you want to modify the database creation scripts before executing them.

You can create or modify the MES database. By default, the utility creates the MES database and you can change the name of the database if you are using SQL Server. If a database is migrated, the originating database name is retained.

Migration of the database does not create the custom indexes, views, procedures and functions that are created by the user. The user has to manually recreate these entities.

You can dump all of the embedded resources in the database configuration to the

FactDbResources directory using the Database Configuration Utility.

This option is useful when you run into specific problems during the execution of the default database script files. You can dump the database scripts at a specific location in your computer.

If you choose to select the Dump Database Scripts to Disk, you cannot run the scripts manually. You must run the same Database Configuration Utility to create your database which will run the scripts you dumped to disk by default.

You can use the dumped database scripts from a specific location in your computer, edit the scripts, and then re-execute the utility to create the database based on the modifications. The utility fetches the edited file for execution instead of the file in the memory.

If you run the utility again after dumping the scripts, the utility always uses the dumped scripts and prompts a warning message Local script files is being used. If you want to use the embedded resources in the database configuration, you must delete FactDbResources folder before running the utility. 

Upgrading to Wonderware MES Software/Operations

You can upgrade Wonderware MES Software/Operations from a version not older than 3.4. To upgrade from a version older than 3.4 to the current version of the software, you must first uninstall the previous version, and then install the new version. The MES database Configuration Utility delivered with this release supports migration of databases from version 3.1 and later. Migration from versions earlier than 3.1 requires manual steps to first update the database to version 3.1. Custom modifications to any version of the Factelligence database may not be supported by the utility and may prevent migration.

You must save a copy of the existing middleware configuration file (Middleware.cfg) before uninstalling the existing Wonderware MES version. After the installation is complete, replace the newly created Middleware.cfg file with the original file to restore all connectivity and passwords. Be sure to restart the MES Middleware Host application after replacing this file.

While you are upgrading the Wonderware MES from a previous version, you can click Backup on the Wonderware Database Configuration Utility dialog box, to take a backup of the previous database. This creates a copy of the database, migrates the existing database in the specified place, and retains the data. If you do not want to migrate, create a new database with a different name or rename the original database prior to installing Wonderware MES Software/Operations.