Filip.Gasiorek

Changing AP Databases

Discussion created by Filip.Gasiorek on Jan 18, 2019

At some point in a Product lifecycle there comes a time for a bit of spring cleaning and therefore update(s) to server resources.  However where it is deemed that a server move is necessary; how can this be achieved for the Snow Automation Platform databases, I hear you ask?

 

Well, this situation can be resolved using the following instructions:

 

  1. Take a full back up of the existing SnowAutmationPlatformAzman database (.bak)
  2. Take a full back up of the existing SnowAutmationPlatformDomain database (.bak)
  3. Restore each backup on the new database server (check Snow system requirements to ensure SQL server compatibility)
  4. Ensure that secuity logins are set up for the following accounts (replicate this from the source database security login setup, note that the account names may differ to the recommended naming convention used in the below example):
    • DOMAIN\AP_WorkflowEngine
    • DOMAIN\AP_AppPool
    • DOMAIN\AP_Administrators
  5. Assign the above login accounts to the SnowAutomationPlatformDomain database user list in line with the source database user setup
  6. Assign only the required login accounts from the above list to the SnowAutomationPlatformAzman database user list in line with the source database user setup.  Additionally, ensure that any AzMan users & roles are set up in the target instance, in line with the source database
  7. At the cut off date / time, proceed with the following steps:
    1. Stop AP website via IIS (stop corresponding AppPool)
    2. Change the x86 and x64 SQL Aliases on the corresponding AP application server to point to the the new SQL server (ensure that if a SQL instance is used on the new server, that this is also specified)
    3. Run a test ODBC connection confirming successful connection using the updated SnowAutomationPlatformSQLServer SQL Aliase
    4. Start AP website via IIS (start corresponding AppPool)
    5. Start a new browser session and test AP access
  8. Once access to AP is confirmed, ensure that there are active proesses attached to the new instance of SnowAutomationPlatformDomain database and SnowAutomationPlatformAzman database.  This can be achieved from within SSMS.
  9. Proceed with disposing of the old SnowAutmationPlatformAzman database and SnowAutmationPlatformDomain database from the old SQL server in line with your company policy.

 

Feel free to add any comments / suggestions to improve the overall execution experience in this process.

 

Best Regards,

 

-F-

Outcomes