Versions Compared

Old Version 2

changes.mady.by.user Nadja Pollard

Saved on

compared with

New Version 3

changes.mady.by.user Nadja Pollard

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

To migrate from MySQL to SQL Server 

  1. Stop the up.time Data Collector:
    Code Block
    languagesql
    Unix: #/etc/init.d/uptime_core stop

...

  1. 
Windows: > net stop "up.time data collector"
  2. Dump the database:
    Code Block
    languagesql
    > /scripts/fulldatabasedump
  3. 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.

...