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
RTSolAsked:
Who is Participating?
 
Som TripathiConnect With a Mentor Database AdministratorCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.