Optionally, replicate the entire database or databases to a new machine or machines. Oracle recommends that you replicate the databases.
During database configuration with EPM System Configurator, specify the new product database location.
Note the following about replicating databases:
If the database version needs to be updated, perform the database upgrade before replicating data.
If you want to maintain the earlier release installation, you must replicate the databases.
You do not need to replicate the Shared Services database. Shared Services requires a new database and data from the earlier release is imported during configuration.
If you are upgrading from Essbase Studio Release 11.1.1.3, ensure that the data is valid before you upgrade to ensure successful upgrade.
For Financial Management and MS SQL Server, if you are restoring a backup of an existing database in a new environment, make sure that the current database user has access to the imported database objects. This can be accomplished using a script such as master.sp_change_users_login.
When you are done with this step, return to the Upgrading Checklist.