Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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 :)

share|improve this question

closed as off-topic by Michael Green, Tom V, Julien Vavasseur, Erik, mustaccio Mar 26 at 15:14

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Shopping list question - questions about which tool, library, product or resource you should use are off-topic here because they quickly become obsolete and often are just about the preferences of the answerer. If you have an issue with or a question about a specific tool, please revise your question to conform to that scope." – Michael Green, Tom V, Julien Vavasseur, Erik, mustaccio
If this question can be reworded to fit the rules in the help center, please edit the question.

When you say synchronize, what is your tolerance for latency, and availability requirements? How far out of sync can the instances be, and what is the business expectation in the event of a failure? – Eric Higgins Jul 16 '12 at 16:22
@EricHiggins great questions! They are not to be used as mirrors or anything related to HA. It's strictly for use as test and reporting environments. As for latency, the secondary servers can be 1 hour late by the time they are fully functioning. – ivanmp Jul 16 '12 at 17:27
@AaronBertrand I've just looked at the service from Red Gate. It seems to me it's about SQL Azure (now SQL Databases) and not SQL Server per se, so I don't think it helps in my case :( – ivanmp Jul 16 '12 at 17:30
Sorry I mis-read some of the question. I thought you wanted to synchronize schema between AWS and other, not facilitate something like replication or mirroring in AWS. – Aaron Bertrand Jul 16 '12 at 20:01