The SmartPlant Foundation Server Manager Upgrade Wizard allows you to upgrade the database. You can also create a backup of the database before the upgrade begins.
The Upgrade Wizard compiles a list of available upgrade paths based on the version of SmartPlant Foundation and SPO/E Core that is consistent with the data in the selected site. When you start the Upgrade Wizard, the software reads a control file that defines the available upgrades. The control file, UpgradeControls.xml, and Upgrade folder are delivered to the SPFServerManager subfolder of the product installation folder. For example, [installation directory]\SmartPlant\Foundation\SPFServerManager\UpgradeControls.xml.
-
In Server Manager, right-click a site and click Tools > Upgrade Wizard from the quick menu.
-
In the Upgrade Path page, select your upgrade path from the list of available upgrades and click Next.
-
In the Upgrade Options page, select the actions you would like the Upgrade Wizard to perform and click Next.
-
To upgrade and transform your data, click Upgrade data in the database.
-
To back up your database, click Back up database before upgrade and enter or browse to the location where you want the backup files to be saved.
-
-
In the Ready to Upgrade page, review the scripts that the Upgrade Wizard is preparing to execute and click Next to begin the upgrade.
-
If the wizard runs a procedural SQL script (PL/SQL for Oracle or T-SQL for SQL Server), the tracing output for the script is saved to the Server Manager temp directory under the default root path in a separate log file, UpgradeWizardPLSQLOutput.log or UpgradeWizardTSQLOutput.log, depending on the type of script that was run. The script results are also written to the main log file, UpgradeWizardlog.xml.
-
Critical errors cause the upgrade to stop. Click Back to make changes to your upgrade selections.
-
Non-critical errors are logged, but the upgrade continues.
-
-
In the Upgrade Results page, click Finish to view the log file.
-
Once the SPO/E Core site is configured, you must recycle the application pools to avoid errors.
-
Server Manager logs every action it performs in a log file called UpgradeWizardlog[date]-[time].xml saved in the temp directory under the default root path (for example, C:\SmartPlant Foundation Server Files\Temp\ServerManager).
-