The company I'm currently working with is "moving to the cloud" (isn't everyone these days?)
In this case, they are moving to AWS, and they want a simple and effective way of managing multiple (SQL) servers within AWS without requiring manual work.
They have a (single) SQL Server production server running on AWS.
What they want is to be able to start new instances of EC2 servers at will running SQL Server (for various purposes) and synchronize it with the production server in some automated way. They are very open about what can be used in order to make this work: It could be a set of T-SQL scripts, POSH scripts, freeware tools, commercial tools (or any combination of them.) It doesn't matter the tool, as long as it isn't too complicated to setup and maintain, they just want the job done.
So my question is, what would you recommend for this kind of thing?
Any suggestions (including commercial products) are welcome :)