Would really like to hear about people's experiences with moving databases to the cloud (IaaS or PaaS). We currently have our SQL Server 2005 databases on an internal VM running Windows Server 2003. We've moved most of our web applications to the cloud (IaaS) but have been more reluctant to move the databases. The biggest motivations for us to move databases to the cloud are for the security updates of a newer operating system and to eliminate hardware replacement issues of an older system.
I found this article useful for considering which hosting option in Azure might be best for us:https://docs.microsoft.com/en-us/azure/sql-database/sql-database-paas-vs-sql-server-iaas
We have technical administrative capabilities so I'm leaning toward IaaS for the database, same as we did for our web applications.
Has anyone had negative experiences with databases the cloud? Have you needed to do any database recovery in the cloud? Any insights would be helpful as we consider our options.