How to configure standalone SQL server, Database Mirroring, and Always on High Availability

Instructions

1. Prepare database connection strings as per SQL server configuration.

For the standalone SQL Server connection string:
"Server=<SQL Server Name or FQDN>;Initial Catalog=<Site Database Name>;Integrated Security=True"

For the database Mirroring connection string:
"Server=<Primary SQL Server Name or FQDN>; Initial Catalog=<Site Database Name>;Integrated Security=True; Failover Partner=<Secondary SQL Server Name or FQDN>"

For Always on High Availability connection string:
"Server=<Listener Name or FQDN>; Initial Catalog=<Site Database Name>;Integrated Security=True; MultiSubnetFailover=True"

2. Nullify all service DB connection strings.
3. Set all service DB connection strings.
4. Update all service connections strings accordingly.
5. Nullify Log and Monitor DataStore DB connection strings.
6. Set Log and Monitor DataStore DB connection strings.

Reference Article for migrating DB 

https://support.citrix.com/article/CTX280675