Converting the up.time database from MySQL to SQL Server

To keep your historical performance data and migrate your MySQL database to SQL Server, please complete the following steps:

• Stop the up.time data collector:

Unix: # /etc/init.d/uptime_core stop

Windows: > net stop "up.time data collector"

• Dump the database: > / scripts / fulldatabasedump
• Set up the SQL Server database.
• Edit the uptime.conf file to point to the new database by commenting our the MySQL lines and uncommenting the SQL Server lines.  Example:

#dbDriver=com.mysql.jdbc.Driver

#dbType=mysql

#dbHostname=localhost

#dbPort=3308

#dbName=uptime

#dbUsername=uptime

#dbPassword=uptime

 

#example SQL Server configuration

dbDriver=net.sourceforge.jtds.jdbc.Driver

dbType=mssql

dbHostname=localhost

dbPort=1433

dbName=uptime

dbUsername=user

dbPassword=password

•  Stop the MySQL database:

Unix: # /etc/init.d/uptime_datastore stop

Windows: > net stop "up.time data store"

• Initialize the database: > / resetdb --nodata really
• Import the database to SQL Server: > / scripts / fulldatabaseimport
• Start the data collector:

Unix: # /etc/init.d/uptime_core start

Windows: > net start "up.time data collector"