To keep your historical performance data and migrate your MySQL database to SQL Server, please complete the following steps:
\n- Stop the up.time data collector:
\n\n\nUnix: # /etc/init.d/uptime_core stop
\nWindows: > net stop "up.time data collector"
- \nDump the database: > / scripts / fulldatabasedump
- \nSet up the SQL Server database.
- \nEdit 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\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
\ndbDriver=net.sourceforge.jtds.jdbc.Driver
\ndbType=mssql
\ndbHostname=localhost
\ndbPort=1433
\ndbName=uptime
\ndbUsername=user
\ndbPassword=password
- \nStop the MySQL database:
\n\n\nUnix: # /etc/init.d/uptime_datastore stop
\nWindows: > net stop "up.time data store"
- \nInitialize the database: > / resetdb --nodata really
- \nImport the database to SQL Server: > / scripts / fulldatabaseimport
- \nStart the data collector:
\n\nUnix: # /etc/init.d/uptime_core start
\nWindows: > net start "up.time data collector"