Move from Derby to Oracle

Document ID : KB000091750
Last Modified Date : 16/04/2018
Show Technical Document Details
Question:
I've been unable to find documentation on moving our Service Virtualization from derby to Oracle. Can you point use in the right direction?
Environment:
All Supported DevTest releases.
Answer:
We do not have a tool to export the data from Derby and import it into Oracle.

You will need to start your DevTest components with a clean Oracle database and make sure it is UTF-8.

What you will need to do is to update the following properties in the dradis.properties file:
dradis.db.internal.enabled=false

dradis.db.driverClass=oracle.jdbc.driver.OracleDriver dradis.db.url=jdbc:oracle:thin:@YourHostGoesHere:PortOracleRunningOnGoesHere:OracleDatabaseInstanceGoesHere dradis.db.user=EnterpriseDashboardOracleUserGoesHere dradis.db.password=EnterpriseDashboardOraclePasswordGoesHere

Then make these changes in the site.properties file:
lisadb.pool.common.driverClass=oracle.jdbc.driver.OracleDriver lisadb.pool.common.url=jdbc:oracle:thin:@YourHostGoesHere:PortOracleRunningOnGoesHere:OracleDatabaseInstanceGoesHere
lisadb.pool.common.user=RegistryOracleUserGoesHere lisadb.pool.common.password=EnterpriseDashboardOraclePasswordGoesHere

lisadb.internal.enabled=false

NOTE: The User for both Enterprise Dashboard and Registry must have DBA Authority unless you DBA is creating the tables. Once the property files are configured, bring down all of your DevTest components. Then start all of your DevTest components.
Additional Information:
Refer to the document sections for what release you are on:

External Enterprise Dashboard Database for Oracle

External Registry Database for Oracle