As I understand it if you are using mirroring on SQL server and have failover setup you can adjust the connection strings of your applications that use it so they know the name of the other server ...

AWS today announced a new database product that is clearly meant to go after Microsoft’s SQL Server and make it easier — and cheaper — for SQL Server users to migrate to the AWS cloud.