Page History

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

To migrate from MySQL to SQL Server 

Stop the up.time Data Collector:

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

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

Dump the database:

> /scripts/fulldatabasedump

...

Set up the SQL Server database.

...

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

#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"