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 data collectorData Collector 

    Code Block
    languagetext
    Unix: #/etc/init.d/uptime_core stop 
    Windows: > net stop "up.time data collector"
  2. Dump the database:

    Code Block
    languagetext
     > /scripts/fulldatabasedump
  3. Set up the SQL Server database.
  4. Edit the uptime.conf file to point to the new database by commenting out the MySQL lines and uncommenting the SQL Server lines. 

    Code Block
    languagetext
    #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
  5. Stop the MySQL database: 

    Code Block
    languagetext
    Unix: # /etc/init.d/uptime_datastore stop  
    Windows: > net stop "up.time data store"
  6. Initialize the database:

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

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

    Code Block
    languagetext
    Unix: # /etc/init.d/uptime_core start  
    Windows: > net start "up.time data collector"