Take the 2-minute tour ×
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. It's 100% free, no registration required.

We have an existing Microsoft 2008 SQL R2 database that we need to real time replicate to an identical off-site live web database. Transactional replication and merge replication will not be able to work for us. Can anyone suggest a different tool or replication type that will allow for us to have the two live SQL databases (one in house and and the web db)?

share|improve this question

closed as off topic by Jack Douglas Oct 17 '12 at 14:14

Questions on Database Administrators Stack Exchange are expected to relate to database administration within the scope defined by the community. Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope. Read more about reopening questions here.If this question can be reworded to fit the rules in the help center, please edit the question.

Unfortunately this kind of question is off-topic here–please see the faq for details –  Jack Douglas Oct 17 '12 at 14:14
How is this off-topic @JackDouglas, care to explain? Looks perfectly on-topic to me. –  ivanmp Oct 17 '12 at 14:18
@ivanmp sure, from the faq: "Chatty, open-ended questions diminish the usefulness of our site and push other questions off the front page". See also this on mSO for more details. You could possibly edit into an on-topic question but it shouldn't look like a poll or 'shopping list' –  Jack Douglas Oct 17 '12 at 14:22
@JackDouglas oh, I see now. Thank you for the explanation :) –  ivanmp Oct 17 '12 at 15:01
For my own knowledge, how could it be made better / legit? By just asking if there are any alternatives, or would that still be to close to "shopping"? –  Eric Higgins Oct 17 '12 at 15:50