Prepare a new empty database as described in Smart Materials Database Creation.
Do not perform the fresh installation as described in Smart Materials Database Fresh Install.
Compare the source database with the target database. Resize the target database if it´s necessary and add all missing database files and schemas.
If Smart Materials Web (formerly BIR) is installed on the source database and must be migrated, you must create the following tablespaces in the target database before you import the dump file:
-
BIR_SPMAT
-
APEX_xxxx (This tablespace was automatically created on the source database during the BIR installation, with xxxx representing a 16 digit random number)
Make sure you create the tablespaces with exactly identical names as in the source database.
The M_SYS schema must not yet exist on this database.
Any custom applications created within the APEX (BIR) must be exported and imported manually. For more information, see Export and Import Smart Materials Business Custom Applications.