Page History

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"

...

• \n
  Dump the database: > / scripts / fulldatabasedump
• \n
  Set up the SQL Server database.
  \n
• 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

...

• \n
   Stop the MySQL database:

...

                  Unix: # /etc/init.d/uptime_datastore stop

...

                 Windows: > net stop "up.time data store"

...

• \n
  Initialize the database: > / resetdb --nodata really
  \n
• Import the database to SQL Server: > / scripts / fulldatabaseimport
• \n
  Start the data collector:

...

               Unix: # /etc/init.d/uptime_core start

...

               Windows: > net start "up.time data collector"