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:
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.
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.
Use the DBUtil utility to change the database user credentials in the securestore.enc file.