Yep, that is an option. If you can publish the data out as services, then you could leave the DB in Azure.
There are LOTS of considerations when moving any part of your GIS environment to the cloud.
