Move from Derby to SQL Server

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

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

Update for Enterprise Dashboard to point to SQL server. 

Set  dradis.db.internal.enabled=false

Update for Registry Start all DevTest components.


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.