up.time uses MySQL as its default DataStore although MS SQL Server and Oracle are also supported. Please see Supported Databases in up.time for details on supported versions.

 

If you plan to change your DataStore to another supported database, you will need to:

 

Backup and Restore the DataStore

 

up.time includes two command line utilities for backing up and restoring the contents of your DataStore. These utilities (fulldatabasedump and fulldatabaseimport) extract and compress the data from your DataStore. For information on how to use these utilities, see Exporting and Importing Your DataStore.

 

Edit the uptime.conf file

 

To change the default database settings in the uptime.conf file:

 

  1. Stop the up.time services.
  2. Open the uptime.conf file in a text editor.
  3. The first block of settings in the file (starting with dbDriver=com.mysql.jdbc.Driver) contain the MySQL parameters. Either delete this block or comment it out using the hash symbol (#).
  4. If you are using SQL Server as your new DataStore, remove the hash signs (#) from the entry that begins with dbDriver=net.sourceforge.jtds.jdbc.Driver and edit the following settings:
  5. If you are using Oracle as your DataStore, remove the hash signs (#) from the entry that begins with dbDriver=oracle.jdbc.OracleDriver and edit the following settings:
  6. Save the file.
  7. Restart the up.time services.

 

Related Documenation: 

Exporting and Importing Your DataStore