Achieving merge replication with SQL Express 2005

Tags:
Merge replication
SQL Express
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?

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: