Achieving merge replication with SQL Express 2005
Home > IT Answers > SQL Server > Achieving merge replication with SQL Express ...
SQL Server Ask the Experts
2445 pts.
0
Q:
Achieving merge replication with SQL Express 2005
SQL Express, Merge replication, SQL Express 2005
I wish to achieve merge replication with multiple publisher nodes replicating to a central distributor which merges the data and publishes back out. However, I only have access to SQL Express 2005 with only one license for the full edition. Is it possible to achieve this with what I currently have?
ASKED: Oct 2 2008  5:17 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
46795 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Yes you can do this, but the machine with the purchased license will need to be the publisher. You can configure it as the publisher, and all the SQL Express machines as subscribers and setup the merge replication to push (or pull) to all of them.
Last Answered: Oct 2 2008  6:31 PM GMT by Mrdenny   46795 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Mrdenny   46795 pts.  |   Oct 2 2008  6:31PM GMT

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.

 
0