...
Stop the up.time Data Collector:
Code Block language text Unix: #/etc/init.d/uptime_core stop Windows: > net stop "up.time data collector"
Dump the database:
Code Block language text > /scripts/fulldatabasedump
- Set up the SQL Server database.
Edit the uptime.conf and controller\resources\uptime_controller.conf file to point to the new database by commenting out the MySQL lines and uncommenting the SQL Server lines.
Code Block language text #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:
Code Block language text Unix: # /etc/init.d/uptime_datastore stop Windows: > net stop "up.time data store"
Initialize the database:
Code Block language text > / resetdb --nodata really
Import the database to SQL Server:
Code Block language text > /scripts/fulldatabaseimport
Start the data collector:
Code Block language text Unix: # /etc/init.d/uptime_core start Windows: > net start "up.time data collector"