Moving configurations and settings definitions from one database to a different database
You can use the procedure described below to to move Dynamic Workload Console configurations and settings definitions from one database to a different database.
- From the navigation toolbar, click Administration > Manage Settings.
- In the Manage Settings panel, click Export Settings and save the XML file to a directory of your choice.
- Optionally, edit the file using an XML editor and save it.
- Optionally export your custom boards, as described in Exporting and importing a dashboard.
- Stop the Dynamic Workload Console as described in Application server - starting and stopping.
-
Browse to the datasource_<db_vendor>.xml file located
in one of the following paths:
- On UNIX operating systems
- DWC_home/usr/servers/dwcServer/configDropins/templates
- On Windows operating systems
- DWC_home\usr\servers\dwcServer\configDropins\templates
-
Copy the datasource_<db_vendor>.xml to the path for
your operating system:
- On UNIX operating systems
- DWC_DATA_dir/usr/servers/dwcServer/configDropins/overrides
- On Windows operating systems
- DWC_home\usr\servers\dwcServer\configDropins\overrides
- Configure the datasource_<db_vendor>.xml file based on the specifics of your environment.
-
Only if you are moving from an Oracle database to a different database, browse
to the following files:
- DWC_DATA_dir>/usr/servers/dwcServer/apps/DWC.ear/DWCRest.war/META-INF/orm.xml
- DWC_DATA_dir/usr/servers/dwcServer/apps/DWC.ear/Reporting.war/META-INF/orm.xml
- DWC_DATA_dir/usr/servers/dwcServer/apps/DWC.ear/TWSWebUI.war/META-INF/orm.xml
-
Only if you are moving to an Oracle database, browse to the following
files:
- DWC_DATA_dir>/usr/servers/dwcServer/apps/DWC.ear/DWCRest.war/META-INF/orm.xml
- DWC_DATA_dir/usr/servers/dwcServer/apps/DWC.ear/Reporting.war/META-INF/orm.xml
- DWC_DATA_dir/usr/servers/dwcServer/apps/DWC.ear/TWSWebUI.war/META-INF/orm.xml
- Restart the Dynamic Workload Console as described in Application server - starting and stopping.
- Click Import Settings and browse to the XML file containing the settings you want to import.
- Import custom boards, as described in Exporting and importing a dashboard.