Use the following guidelines to upgrade the EcoSys (ESFM) database instance for Oracle or Microsoft SQL Server.
Execute the database upgrade scripts
-
Locate the database upgrade scripts folder in the EcoSys installation/upgrade package for the database platform being used.
-
For Oracle databases, use /EcoSys/database/oracle/upgrades.
-
For Microsoft SQL Server databases, use /EcoSys/database/sqlserver/upgrades.
-
-
Open and view the contents of each script that you need to run prior to doing so. Some scripts require different permissions or may need a path in the script changed.
-
Starting with the current database schema version and ending with the target database schema version, execute all database scripts in order.
-
If an error or warning occurs, do not proceed with the next script. Contact EcoSys Support.
-
Save the log files for each script execution as they may be needed for troubleshooting purposes.