Initialize the database

Initialize the database automatically

The Data Repository item has an AutoUpgrade property that has a default value of True. When this value is True, AVEVA™ Production Management automatically performs functions that are associated with the Initialize Database command every time the Data Repository item starts.

• If the database does not exist, the Initialize Database command creates a new SQL database and creates the schema of the database.

• If the database exists previously, the Initialize Database command causes the database to upgrade the schema to the current version.

• Checks for minimum SQL requirements and sets the SQL compatibility.

• If not installed, installs the CLR Stored Procedure.

If you want to control when the data repository initializes, set the AutoUpgrade property to False and only perform the Initialize Database command manually.

Initialize the database manually

If you have set the AutoUpgrade property on the Data Repository item to False, you can perform database initializations only by manual method. You may want to do this during an upgrade process to gain greater control.

• Expand the System Configuration folder, then right-click the Data Repository item, and select Initialize Database.

Related topics

• Data repository

• System configuration