move afaria database

[Former Member]

Hi,

I wish to move our current afaria 6.60 database from a SQL 2005 to a SQL 2008 R2 instance, what is the process for doing this please?

[jose_at_sap]

Hi Stevan,

The best place to answer this question is in the Afaria community page, part of the space.

This space is for the SQL Anywhere database (not Microsoft SQL Server!)  I'll be more than happy to tell you how to migrate from SQL 2005 to SQL Anywhere 16, but somehow I don't think that's what you want to do

[Former Member]

Hi Jose,

Appreciate the response, sadly i didn't post this thread in this forum, it got moved here

Hello,

You have received
this email because the content you posted below has been moved to SAP SQL Anywhere by SCN
moderators

kind regards

[JasonHinsperger]

Stevan,

   Where did you originally post the question?

Also, FYI, I just moved your question to the SAP for Mobile space, where Afaria questions are typically answered.

--Jason

[Former Member]

Hi Jason,

Thanks for moving it to the correct forum. To be honest i've forgotten what forum it started in. hopefully now it is here that will help.

regards

[Former Member]

Hi Stevan,

I do this when I move Afaria databases:

1. Shut down all services
2. Move the actual database incl. logins
3. Edit registry on Afaria server
   1. HKEY_LOCAL_MACHINE\SOFTWARE\Afaria\Afaria\Server\Logging\Database\DBServer
   2. HKEY_LOCAL_MACHINE\SOFTWARE\Afaria\Afaria\Server\Setup\LogServer
   3. HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\SQL Server Afaria Log\Server
   4. HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\SQL Server Afaria API Host\Server
4. Same keys under Wow6432Node
5. Start services (or reboot)
   
6. Check Event log.

BR

Peter

[Former Member]

Thanks Peter,

Will give that a go

Regards

[Former Member]

Sorry.. Afaria 7 uses these keys:

HKEY_LOCAL_MACHINE\SOFTWARE\Afaria\Afaria\ApiService\Setup\Farm\DBServer

1. HKEY_LOCAL_MACHINE\SOFTWARE\Afaria\Afaria\Server\Logging\Database\DBServer
2. HKEY_LOCAL_MACHINE\SOFTWARE\Afaria\Afaria\Server\Setup\LogServer
3. HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\SQL Server Afaria Log\Server
4. HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\SQL Server Afaria API Host\Server

[Former Member]

cheers, we are on 6.60 so i should be using the keys from the first post?

[Former Member]

Yes...