main
ROOT /
pages /
use-external-database.md
20 lines | ISO-8859-1 | 1 KB

Use External Database


By default, OneDev uses the embedded HSQL database for demonstration purpose. For production usage, it is highly recommended to switch to external database for reliability and performance reason. OneDev can work with below databases:

  • MySQL 5.0 or higher
  • Oracle 9i or higher
  • SQL Server 2008 or higher
  • PostgreSQL 9.0 or higher
  • MariaDB 5.0 or higher

To switch to use one of above databases, follow below steps (assume OneDev is installed at /opt/onedev):

  1. Stop OneDev server by running /opt/onedev/bin/server.sh stop (or run server.bat on Windows)
  2. Run command /opt/onedev/bin/backup.(sh|bat) /path/to/backup-file
  3. Edit file /opt/onedev/conf/hibernate.properties to comment out the HSQLDB section and uncomment the section of your desired external database. Also provide connection details to your database
  4. Create a blank external database matching connection details of above step
  5. Run command /opt/onedev/bin/restore.(sh|bat) /path/to/backup-file
  6. Start OneDev server and check if everything is fine

Procedure is the same if you want to switch to a different external database than current external database.

Please wait...
Page is in error, reload to recover