Page History

...

To migrate from MySQL to SQL Server 

1. Stop the up.time Data Collector:
   

   Code Block
   language sql
   Unix: #/etc/init.d/uptime_core stop

...

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

2. Dump the database:
   

   Code Block
   language sql
   > /scripts/fulldatabasedump

3. Set up the SQL Server database.
4. Edit

...

1. 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.
   

   Code Block
   language sql
   #dbDriver=com.mysql.jdbc.Driver

...

1. #dbType=mysql

...

1. #dbHostname=localhost

...

1. #dbPort=3308

...

1. #dbName=uptime

...

1. #dbUsername=uptime

...

1. #dbPassword=uptime

...

1. #example SQL Server configuration

...

1. dbDriver=net.sourceforge.jtds.jdbc.Driver

...

1. dbType=mssql

...

1. dbHostname=localhost

...

1. dbPort=1433

...

1. dbName=uptime

...

1. dbUsername=user

...

1. dbPassword=password

   
   
2. Stop the MySQL database:
   

   Code Block
   language sql
   Unix: # /etc/init.d/uptime_datastore stop

...

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

2. Initialize the database:
   

   Code Block
   language sql
   > /resetdb --nodata really

3. Import the database to SQL Server:
   

   Code Block
   language sql
   > /scripts/fulldatabaseimport

4. Start the data collector:
   

   Code Block
   language sql
   Unix: # /etc/init.d/uptime_core start

...

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