Question

FSM schema export and import backup restoration in oracle?

  • 24 November 2020
  • 1 reply
  • 90 views

Userlevel 4
Badge +8

Hi,

If i have taken the expdp backup of FSM schema from one database (ex:dev)  in oracle and import the same FSM schema in another database (ex: Test ) in oracle and configure only the application in Test environment. All the configuration, code, data will be available in the Test environment.

Kindly Confirm whether the above process work.


1 reply

Userlevel 6
Badge +22

Hi @TatKhandM ,

you should consider exporting the metrix_app_params and threesixty_app_params (if PSO is used as well) from the destination environment prior importing the source database. After Import you should import them back to ensure you have the correct app params.

Afterwards, re-run the FSM Installer for the App Server/Mobile. If you have custom assemblies, custom reports, etc. used in the source environment you might need to copy them manually to the target environment (or include in the Installer package and re-run Installer).

Best regards

Roman

Reply