Use the current and target EcoSys (ESFM) database schema versions, as well as the database platform, to determine which database scripts you need to run.
Determine the current database schema version
Use of of the following methods:
-
Prior to shutting down the EcoSys application server(s), log in to the EcoSys web application, navigate to System Information > Database, and make a note of the Current Database Version value.
-
Execute the following SQL query as the FMUSER database user:
Select database_version_name from systemsettings
Determine the target database schema version
Use one of the following methods:
-
Open the EcoSys Release Notes for the target/upgrade version, and make a note of the required schema version value listed under Database Schema Version.
-
Locate the EcoSys target/upgrade version EcoSys Release column, and make a note of its corresponding Database Schema Version value.
EcoSys Release |
Database Schema Version |
Database Upgrade Script to Run |
---|---|---|
7.0.01 |
0600.0005.0005 |
fm_or_upgrade_0600_0005_0004_0001_to_0600_0005_0005_0001.sql |
7.0.02 |
0600.0005.0005 |
No database scripts required. |
7.0.03 |
0600.0005.0005 |
No database scripts required. |
7.0.04 |
0600.0006.0003 |
fm_or_upgrade_0600_0005_0005_0001_to_0600_0006_0001_0001.sql |
7.1.01 |
0600.0006.0009 |
fm_or_upgrade_0600_0006_0001_0001_to_0600_0006_0002_0001.sql |
7.2.01 |
0600.0007.0003 |
fm_or_upgrade_0600_0007_0001_0001_to_0600_0007_0002_0001.sql |
7.2.02 |
0600.0007.0004 |
fm_or_upgrade_0600_0007_0003_0001_to_0600_0007_0004_0001.sql |
7.2.03 |
0600.0007.0004 |
No database scripts required. |
7.2.04 |
0600.0007.0006 |
fm_or_upgrade_0600_0007_0004_0001_to_0600_0007_0005_0001.sql |
7.2.05 |
0600.0007.0007 |
fm_or_upgrade_0600_0007_0006_0001_to_0600_0007_0007_0001.sql |
7.0.06 |
0600.0007.0007 |
No database scripts required. |
7.3.01 |
0600.0007.0008 |
fm_or_upgrade_0600_0007_0007_0001_to_0600_0007_0008_0001.sql |
7.4.01 |
0600.0007.0011 |
fm_or_upgrade_0600_0007_0008_0001_to_0600_0007_0009_0001.sql |
7.4.02 |
0600.0007.0011 |
No database scripts required. |
7.4.03 |
0600.0007.0015 |
fm_or_upgrade_0600_0007_0011_0001_to_0600_0007_0012_0001.sql |
7.4.04 |
0600.0007.0015 |
No database scripts required. |
7.4.05 |
0600.0007.0015.0001 |
No database scripts required. |
7.4.06 |
0600.0007.0015.0001 |
No database scripts required. |
7.4.07 |
0600.0007.0015.0001 |
No database scripts required. |
7.4.08 |
0600.0007.00170001 |
fm_or_upgrade_0600_0007_0015_0001_to_0600_0007_0016_0001.sql |
7.0.09 |
0600.0007.00170001 |
No database scripts required. |
7.4.10 |
0600.0007.00170001 |
No database scripts required. |
7.4.11 |
0600.0007.00170001 |
No database scripts required. |
7.5.01 |
0600.0008.0011.0001 |
fm_or_upgrade_0600_0007_0017_0001_to_0600_0008_0001_0001.sql |
7.5.02 |
0600.0008.0011.0001 |
No database scripts required. |
7.5.03 |
0600.0008.0011.0001 |
No database scripts required. |
7.6.01 |
0600.0009.0004.0001 |
fm_or_upgrade_0600_0008_0011_0001_to_0600_0008_0012_0001.sql |
7.6.02 |
0600.0009.0004.0001 |
No database scripts required. |
7.6.03 |
0600.0010.0007.0001 |
fm_or_upgrade_0600_0009_0004_0001_to_0600_0009_0005_0001.sql |
7.6.04 |
0600.0010.0007.0001 |
No database scripts required. |
7.7.01 |
0600.0011.0001.0001 |
fm_or_upgrade_0600_0010_0007_0001_to_0600_0011_0001_0001.sql |
7.7.02 |
0600.0011.0001.0001 |
No database scripts required. |
8.0.01 |
0600.0012.0003.0001 |
fm_or_upgrade_0600_0011_0001_0001_to_0600_0011_0002_0001.sql |
8.0.02 |
0600.0012.0003.0001 |
No database scripts required. |
8.0.03 |
0600.0012.0003.0001 |
No database scripts required. |
8.1.01 |
0600.0012.0004.0001 |
fm_or_upgrade_0600_0012_0003_0001_to_0600_0012_0004_0001.sql |
8.1.02 |
0600.0012.0004.0001 |
No database scripts required. |
8.2.01 |
0600.0013.0006.0001 |
fm_or_upgrade_0600_0012_0004_0001_to_0600_0012_0005_0001.sql fm_or_upgrade_0600_0013_0005_0001_to_0600_0013_0006_0001.sql |
8.2.02 |
0600.0013.0008.0001 |
fm_or_upgrade_0600_0013_0006_0001_to_0600_0013_0007_0001.sql |
8.2.03 |
0600.0013.0009.0001 |
fm_or_upgrade_0600_0013_0008_0001_to_0600_0013_0009_0001.sql |
8.3.01 |
0600.0014.0002.0001 |
fm_or_upgrade_0600_0013_0009_0001_to_0600_0014_0001_0001.sql |
8.3.02 |
0600.0014.0003.0001 |
fm_or_upgrade_0600_0014_0002_0001_to_0600_0014_0003_0001.sql |
8.4.01 |
0600.0015.0002.0001 |
fm_or_upgrade_0600_0014_0003_0001_to_0600_0015_0001_0001.sql |
8.4.02 |
0600.0015.0002.0001 |
No database scripts required. |
8.5.01 |
0600.0016.0003.0001 |
fm_or_upgrade_0600_0015_0002_0001_to_0600_0016_0001_0001.sql fm_or_upgrade_0600_0016_0001_0001_to_0600_0016_0002_0001.sql fm_or_upgrade_0600_0016_0002_0001_to_0600_0016_0003_0001.READMENote 1 |
8.6.01 |
0600.0017.0002.0001 |
fm_or_upgrade_0600_0016_0003_0001_to_0600_0017_0001_0001.sql |
8.6.02 |
0600.0017.0002.0001 |
No database scripts required. |
8.6.03 |
0600.0017.0002.0001 |
No database scripts required. |
8.7.01 |
0600.0018.0002.0001 |
fm_or_upgrade_0600_0017_0002_0001_to_0600_0018_0001_0001.sql fm_or_upgrade_0600_0018_0001_0001_to_0600_0018_0002_0001.sql |
8.7.02 |
0600.0018.0002.0001 |
No database scripts required. |
8.7.03 |
0600.0018.0002.0001 |
No database scripts required. |
8.8.01 |
0600.0019.0004.0001 |
fm_or_upgrade_0600_0018_0002_0001_to_0600_0019_0001_0001.sql fm_or_upgrade_0600_0019_0001_0001_to_0600_0019_0002_0001.sql fm_or_upgrade_0600_0019_0002_0001_to_0600_0019_0003_0001.sql fm_or_upgrade_0600_0019_0003_0001_to_0600_0019_0004_0001.sql |
8.8.02 |
0600.0019.0005.0001 |
fm_or_upgrade_0600_0019_0004_0001_to_0600_0019_0005_0001.sql |
8.8.03 |
0600.0019.0006.0001 |
fm_or_upgrade_0600_0019_0005_0001_to_0600_0019_0006_0001.sql |
8.8.04 |
0600.0019.0007.0001 |
fm_or_upgrade_0600_0019_0006_0001_to_0600_0019_0007_0001.sql |
8.8.05 |
0600.0019.0007.0001 |
No database scripts required. |
8.8.06 |
0600.0019.0007.0001 |
No database scripts required. |
8.8.07 |
0600.0019.0007.0001 |
No database scripts required. |
9.0.01 |
0600.0020.0004.0001 |
fm_or_upgrade_0600_0019_0007_0001_to_0600_0020_0001_0001.sql fm_or_upgrade_0600_0020_0001_0001_to_0600_0020_0002_0001.sql fm_or_upgrade_0600_0020_0002_0001_to_0600_0020_0003_0001.sql fm_or_upgrade_0600_0020_0003_0001_to_0600_0020_0004_0001.sql |
9.1.01 |
0600.0021.0010.0001 |
Use Liquibase to apply schema changes. |
9.1.02 |
0600.0021.0010.0001 |
No database scripts required. |
9.2.01 |
0600.0021.0016.0001 |
Use Liquibase to apply schema changes |
9.2.02 |
0600.0021.0016.0001 |
Use Liquibase to apply schema changes |
9.1.03 |
0600.0021.0010.0001 |
No database scripts required |
9.0.03 |
0600.0020.0004.0001 |
No database scripts required |
Database schema versions for EcoSys versions 9.1 and above are not shown in the table.
Upgrading from Schema Version 0600.0016.0002.0001 to 0600.0016.0003.0001
The upgrade script fm_or_upgrade_0600_0016_0002_0001_to_0600_0016_0003_0001.sql is produced by EcoSys during the application startup. The SQL script generated is specific to the environment that was created for and must only be executed on that database. When upgrading from an older version of EcoSys to a newer version you should:
-
Apply all the database upgrade scripts up until fm_or_upgrade_0600_0016_0002_0001_to_0600_0016_0003_0001.sql.
-
Deploy the version of EcoSys you are upgrading to and start your application Server.
-
Review the log files and find the directory containing the generated script fm_or_upgrade_0600_0016_0002_0001_to_0600_0016_0003_0001.sql. This must be the ESFM_HOME\Schema directory.
-
Shutdown the Application Server running EcoSys.
-
Apply the database upgrade script fm_or_upgrade_0600_0016_0002_0001_to_0600_0016_0003_0001.sql
-
Continue applying any additional upgrade scripts required for the upgrade.
-
Start the Application Server to start EcoSys.
Determine which database upgrade scripts to run
All database upgrade scripts listed between the current and target database schema versions in the table above need to be run.
-
All scripts listed in the table above are for environments with Oracle databases. For Microsoft SQL Server databases, replace fm_or with fm_ss in the script names.
-
Pay extra attention to the database upgrade scripts shown in bold text. Depending on the database platform (Oracle versus Microsoft SQL Server), you may need to run these scripts with elevated database user privileges.