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:

               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"