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?