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

1. Stop the up.time data collector:
   

    

Unix: # /etc/init.d/uptime_core stop 
Windows: > net stop "up.time data collector"

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

#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

1.  Stop the MySQL database:
    Unix: # /etc/init.d/uptime_datastore stop
    Windows: > net stop "up.time data store"
2. Initialize the database: > / resetdb --nodata really
3. Import the database to SQL Server: > / scripts / fulldatabaseimport
4. Start the data collector:
   Unix: # /etc/init.d/uptime_core start
   Windows: > net start "up.time data collector"