Optimizing database migration in high availability and disaster recovery computing environments

A non-transitory computer readable storage medium comprising program instructions executable to:

• operate an old primary database server and an old secondary database server in a mirroring configuration to mirror a database from the old primary database server to the old secondary database server, wherein the database on the old secondary database server that is mirrored from the old primary database server is not readable while accessible from the old primary database server, wherein the mirroring configuration employs employing a first encryption method to connect the old primary database server with the old secondary database server, the old primary database server and the old secondary database server operate exterior to a high availability group cluster as a result of the mirroring configuration;
• provide a new primary database server having an endpoint, wherein the endpoint is compatible with the first encryption method and a second encryption method, wherein the new primary database server is configured for inclusion in the high availability group cluster, wherein the second encryption method is an encryption method employed in the high availability group cluster and is different from the first encryption method;
• disable database mirroring between the old primary database server and the old secondary database server;
• configure database mirroring between the old primary database server and the new primary database server using the endpoint while the endpoint is configured to connect with the old primary database server using the first encryption method;
• perform mirroring of the database between the old primary database server and a database of the new primary database server while the endpoint is configured to connect to the old primary database server using the first encryption method, wherein the mirroring of the database between the old primary database server and the database of the new primary database server occurs exterior to the high availability group cluster, the new primary database server operates as a non-readable secondary database server while performing the mirroring;
• perform a failover operation upon synchronization of the database between the old primary database server and the database of the new primary database server, wherein the failover operation comprises executing migration operations to enable functioning of the database at the new primary database server;
• disable the database mirroring between the old primary database server and the new primary database server;
• and
• enable the new primary database server and the database of the new primary database server for operation in the high availability group cluster, wherein the endpoint of the new primary database server is operable for connection with other servers in the high availability group cluster using the second encryption method, wherein the high availability group cluster is capable of concurrently using one or more readable secondary databases.

A system comprising:

• a plurality of networked servers, wherein each of the plurality of networked servers includes one or more processors, and a memory coupled to the one or more processors, wherein the memory stores program instructions executable by the one or more processors to:
• operate an old primary database server and an old secondary database server in a mirroring configuration to mirror a database from the old primary database server to the old secondary database server, wherein the database on the old secondary database server that is mirrored from the old primary database server is not readable while accessible from the old primary database server, wherein the mirroring configuration employs employing a first encryption method to connect the old primary database server with the old secondary database server;
• provide a new primary database server having an endpoint, wherein the endpoint is compatible with the first encryption method and a second encryption method, wherein the new primary database server is configured for inclusion in the high availability group cluster, wherein the second encryption method is an encryption method employed in the high availability group cluster and is different from the first encryption method;
• disable database mirroring between an old primary database server and an old secondary database server;
• configure database mirroring between the old primary database server and the new primary database server using the endpoint while the endpoint is configured to connect with the old primary database server using the first encryption method;
• perform mirroring of the database between the old primary database server and a database of the new primary database server while the endpoint is configured to connect to the old primary database server using the first encryption method, wherein the mirroring of the database between the old primary database server and the database of the new primary database server occurs exterior to the high availability group cluster;
• perform a failover operation upon synchronization of the database between the old primary database server and the database of the new primary database server, wherein the failover operation comprises executing migration operations to enable functioning of the database to the new primary database server;
• disable the database mirroring between the old primary database server and the new primary database server;
• and
• enable the new primary database server and the database of the new primary database server for operation in the high availability group cluster, wherein the endpoint of the new primary database server is operable for connection with other servers in the high availability group cluster using the second encryption method, wherein the high availability group cluster is capable of concurrently using one or more readable secondary databases.