Page History

...

1. Stop the up.time Data Collector:  

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

2. Dump the database:

   Code Block
   language text
   > /scripts/fulldatabasedump

3. Set up the SQL Server database.

4. Edit the uptime.conf and controller\resources\uptime_controller.conf file to point to the new database by commenting out the MySQL lines and uncommenting the SQL Server lines. 

   Code Block
   language text
   #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
   language text
   Unix: # /etc/init.d/uptime_datastore stop   Windows: > net stop "up.time data store"

6. Initialize the database:

   Code Block
   language text
   > / resetdb --nodata really

7. Import the database to SQL Server:

   Code Block
   language text
   > /scripts/fulldatabaseimport

8. Start the data collector: 

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