-2

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?

tombull89
  • 2,964
  • 8
  • 41
  • 52
Robert H
  • 101
  • 4
  • @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. – Sven Sep 26 '12 at 19:18

1 Answers1

2

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

Sven
  • 98,649
  • 14
  • 180
  • 226
  • 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