Advanced Authentication DataBase Migration
search cancel

Advanced Authentication DataBase Migration

book

Article ID: 264135

calendar_today

Updated On:

Products

CA Strong Authentication CA Advanced Authentication - Strong Authentication (AuthMinder / WebFort) CA Advanced Authentication - Risk Authentication (RiskMinder / RiskFort) CA Risk Authentication

Issue/Introduction

Migrating the current DB from existing MSSQL 2017 Farm to a new MSSQL 2019 Farm.

Please share the steps that need to be followed post DB migration.

Environment

Component: Advanced Authentication
Release : 9.1

Resolution

Follow these best practices while migrating DB from one server to another server machine:

  1. arcotcommon.ini file located in <ARCOT_HOME>\conf has a section for Primary DB ([arcot/db/primarydb]) and a section for Backup DB ([arcot/db/backupdb]). Please populate these sections with the updated DB hostnames/ports.

  2. For Windows, update the Primary and Backup DSN configuration from odbc application with the updated DB hostname/port and test the connectivity.
    For Linux, update HostName/Port in ARCOT_HOME/odbc64/odbc.ini file in a text editor.

  3. Use the DBUtil utility to change the database user credentials in the securestore.enc file.