Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

As the question states, which server is easiest to setup replication for?

My needs are:

A local master and a remote (VPN connected) slave.

I am no where near expert in either database so which would be the easiest to configure and maintain? Also what literature would be recommended to ensure success in either database?

share|improve this question

closed as not a real question by MDMarra, Zoredache, Dave M, Scott Pack, HopelessN00b Oct 30 '12 at 14:05

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.

    
@downvoter: Care to explain why this was downvoted? –  Robert H Sep 26 '12 at 19:02
2  
You're effectively asking "What should I eat for dinner? Pasta or fish tacos?" They're two completely different things. We have no idea what your application needs are, what method you need for replication. Sync or Async. etc etc. –  MDMarra Sep 26 '12 at 19:02
    
@MDMarra Aside from the fact that Pasta wins, I am looking for an honest opinion based upon the communities experience. I understand the inherent risks of a flame war, however I need to come to a decision and I felt this is the best resource to use in reaching that decision. –  Robert H Sep 26 '12 at 19:04
    
If you read the faq, questions that ask for opinion, polling, or discussion are clearly off-topic. There is no way for anyone to authoritatively answer this, since any answer will be prefaced with "It depends." –  MDMarra Sep 26 '12 at 19:05
    
@RobertH: You don't need to edit your question to include the answer, that's what the answer fields are for. Just accept an answer if it helped you, which will tell everyone that this solution worked. –  SvW Sep 26 '12 at 19:18
show 1 more comment

1 Answer

up vote 2 down vote accepted

It's quite easy: MySQL, as SQL Server Express can only work as a replication slave.

http://msdn.microsoft.com/library/ms151819%28v=sql.105%29.aspx

share|improve this answer
    
Thanks - I was unaware of that limitation. –  Robert H Sep 26 '12 at 19:07
    
If you don't need real-time (or close) replication for SQL Express but are just using it for DR, you can script a backup, remote copy, and remote restore pretty easily. –  MDMarra Sep 26 '12 at 19:07
add comment

Not the answer you're looking for? Browse other questions tagged or ask your own question.