• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 407
  • Last Modified:

Merge replication

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
RTSol
Asked:
RTSol
1 Solution
 
Som TripathiCommented:
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
 
RTSolAuthor Commented:
Thanks
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now