Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

To keep your historical performance data and migrate your Uptime Infrastructure Monitor datastore from a MySQL database to SQL Server, please complete the following steps:

  1. Stop the up.time

...

  1. Data Collector:

...

  1.   

...

  1. Code Block
    languagetext
    Unix: #/etc/init.d/uptime_core

...

  1.  stop 
    Windows: > net stop "up.time data collector"

 

  1. Dump the database:

    Code Block
    languagetext
     > /scripts/fulldatabasedump
  2. Set up the SQL Server database.
  3. Edit the <uptime_dir>\uptime.conf and <uptime_dir>\controller\resources\uptime_controller.conf file to point to the new database by commenting

...

  1. out the MySQL lines and uncommenting the SQL Server lines. 

...

 

...

  1. Code Block
    languagetext
    #dbDriver=com.mysql.jdbc.

...

           #dbType=mysql

           #dbHostname=localhost

           #dbPort=3308

           #dbName=uptime

           #dbUsername=uptime

           #dbPassword=uptime

 

      #example SQL Server configuration

...

  1. Driver  
    #dbType=mysql 
    #dbHostname=localhost  
    #dbPort=3308  
    #dbName=uptime  
    #dbUsername=uptime  
    #dbPassword=uptime  
     
    #example SQL Server configuration  
    dbDriver=net.sourceforge.jtds.jdbc.

...

  1. Driver  
    dbType=

...

  1. mssql 
    dbHostname=

...

  1. localhost  
    dbPort=

...

  1. 1433  
    dbName=

...

  1. uptime  
    dbUsername=

...

  1. user  
    dbPassword=password

 

...

  1. Stop the MySQL database:

...

  1.  

...

  1. Code Block
    languagetext
    Unix: # /etc/init.d/uptime_datastore

...

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

 

  1. Initialize the database:

    Code Block
    languagetext
    > / resetdb --nodata really
  2. Import the database to SQL Server:

    Code Block
    languagetext
    > /scripts/fulldatabaseimport
  3. Start the data collector:

...

  1.  

...

  1. Code Block
    languagetext
    Unix: # /etc/init.d/uptime_core

...

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