[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Merge replication

Posted on 2011-02-13
2
Medium Priority
?
402 Views
Last Modified: 2012-05-11
Hi,

I have this stituation: At the main office there is a SQL server 2005 standard and at a sales office there is a SQL server Express 2008 R2. Now I want to replicate them so they allways are the same - when one server changes these changes are passed on to the other and vice versa - I beleive this would be a merge replication - right?

My question is - can this be done with this configuration. I understand the the SQL server Express 2008 R2 only supports subscription - is that a problem here?

Is there something in particular I should have in mind?

Best regards
RTSol
0
Comment
Question by:RTSol
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 8

Accepted Solution

by:
Som Tripathi earned 2000 total points
ID: 34882714
Yes, you can do this.
Express Edition can be subscriber only, so this will do and updates on subscriber end would also be merged.
0
 

Author Closing Comment

by:RTSol
ID: 34882901
Thanks
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

656 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question