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"