cancel
Showing results for 
Search instead for 
Did you mean: 

How do I change Afaria database?

former_member686053
Active Participant
0 Kudos

Hi,

I have to change Afaria Database from MSSQL to SQL anywhere.

Have you ant article about it?

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

You have likely resolved this issue by now, but in the event you haven't the process of moving Afaria from one backend database to another is fairly straightforward. The basic process is to simply run the base installer package and define which backend database type you want to use, provide the necessary login credentials and let the installation complete. Then apply any applicable hotfix files (they are removed during this process) to bring your system back up to the appropriate revision level. That's pretty much it. I have done it a few times and have been able to complete the basic move in about 30 minutes per server.

Former Member
0 Kudos

Event easier is to just edit the follow registry keys

  • HKEY_LOCAL_MACHINE\SOFTWARE\Afaria\Afaria\Server\Logging\Database\DBServer
  • HKEY_LOCAL_MACHINE\SOFTWARE\Afaria\Afaria\Server\Setup\LogServer
  • HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\SQL Server Afaria Log\Server
  • HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\SQL Server Afaria API Host\Server

Same keys under Wow6432Node

Process:

  1. Stop all services
  2. Move database from one DB server to the other
  3. Edit registry keys
  4. Start all services

No need to re-install 🙂

Answers (0)