article Converting the up.time database from MySQL to SQL Server

To keep your historical performance data and migrate your MySQL database to SQL Server, please complete the following steps:

  • Stop the up.time data collector:

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

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

  • Dump the database: > / scripts / fulldatabasedump
  • Set up the SQL Server database.
  • Edit the uptime.conf file to point to the new database by commenting our the MySQL lines and uncommenting the SQL Server lines.  Example:

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

Related Articles


Backing up & Recovering up.time

RatingViews
article

This article outlines five ways to back up your up.time DataStore.

By: uptime Support | Date Created: 10-7-2006 | Last Modified: 10-24-2013 | Index: 093

  11498

Securing the up.time MySQL Database

RatingViews
article

By: uptime Support | Date Created: 3-3-2006 | Last Modified: 7-28-2011 | Index: 058

  4090

Migrating Your DataStore To a New Database

RatingViews
article

This article outlines how to move your DataStore between different database types.

By: uptime Support | Date Created: 2-21-2007 | Last Modified: 6-30-2011 | Index: 142

  4645

Default MySQL Database Users and Permissions

RatingViews
article

This article outlines the MySQL database users that are installed with up.time and their permissions

By: uptime Support | Date Created: 7-6-2007 | Last Modified: 6-28-2011 | Index: 211

  3617

How to monitor MySQL Databases with up.time

RatingViews
article

Find out how to use up.time to effectively monitor your MySQL servers and database structures.

By: uptime Support | Date Created: 5-17-2007 | Last Modified: 6-28-2011 | Index: 176

  11050

User Comments



No comments have been posted.

Copyright © 2021 IDERA, Inc.   Legal   Privacy Statement