Move from Derby to SQL Server

Document ID : KB000074551
Last Modified Date : 22/03/2018
Show Technical Document Details
Question:
We are currently using Derby database and want it to switch with SQL 2014 and need assistance with the switch.
Answer:
Brought all the DevTest services down in this order:

VSE, Coordinator, Simulator, Broker, Portal, Registry and Enterprise Dashboard

Update dradis.properties for Enterprise Dashboard to point to SQL server. 

Set  dradis.db.internal.enabled=false

Update site.properties for Registry Start all DevTest components.

lisadb.internal.enabled=false

Start all DevTest components in this order: 

Enterprise Dashboard, Registry, Portal, Broker, Coordinator, Simulator and VSE.

Verified all Services started and now pointing to SQL Server.