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:

\n

\n

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

\n

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

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

\n

\n

#dbDriver=com.mysql.jdbc.Driver

\n

#dbType=mysql

\n

#dbHostname=localhost

\n

#dbPort=3308

\n

#dbName=uptime

\n

#dbUsername=uptime

\n

#dbPassword=uptime

\n

 

\n

#example SQL Server configuration

\n

dbDriver=net.sourceforge.jtds.jdbc.Driver

\n

dbType=mssql

\n

dbHostname=localhost

\n

dbPort=1433

\n

dbName=uptime

\n

dbUsername=user

\n

dbPassword=password

• \n
   Stop the MySQL database:

\n

\n

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

\n

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

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

\n

\n

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

\n

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