Upgrade scenarios

This section describes the installation behavior when a previous version of PI SQL DAS is already installed. The following scenarios are possible:

• PI SQL Data Access Server 1.3.3.0259 or earlier is installed

• PI SQL Data Access Server 1.4.1 is installed

• PI SQL Data Access Server (OLE DB) 1.5 is installed

  In this upgrade scenario, PI SQL Data Access Server (Integrator) is installed and an earlier version of PI SQL Data Access Server is installed to support OLE DB queries.

• Add an earlier version of PI SQL Data Access Server

PI SQL Data Access Server 1.3.3.0259 or earlier installed

PI SQL Data Access Server (Integrator) is installed in parallel. The setup detects that an earlier version is installed and automatically configure port sharing for Net.Tcp. Both versions run in parallel.

PI SQL Data Access Server 1.4.1 installed

This version of the PI SQL Data Access Server supports PI Integrator and OLE DB queries as features, it depends which feature is enabled.

• If the PI Integrator feature is not enabled, the new version of PI SQL Data Access Server (Integrators) is installed in parallel. Port sharing is enabled automatically.

• If the PI Integrator feature is enabled and the OLE DB feature is not enabled, then the new version of PI SQL Data Access Server (Integrators) replaces the previous installation.

• If both PI Integrator and OLE DB features are enabled, the PI Integrator feature is disabled and the new version of PI SQL Data Access Server (Integrator) is installed in parallel. Port sharing is already configured.

PI SQL Data Access Server (OLE DB) 1.5 installed

PI SQL Data Access Server (Integrators) is installed in parallel. Port sharing is enabled automatically.

Note: This is a special situation. PI SQL Data Access Server (Integrator) is installed and a previous version of PI SQL DAS is installed to support OLE DB queries.

Add an older version of PI SQL Data Access Server

The older version of PI SQL Data Access Server (1.4.1 or earlier) is installed in parallel but does not detect that port sharing is required. The PI SQL Data Access Server windows service does not start.

The situation can be fixed in one of the following ways:

• Reinstall PI SQL Data Access Server (Integrators)

• Repair PI SQL Data Access Server (Integrators)

  Note: The repair function is only available in the context menu of the .msi file, but not through the Windows Control Panel.