Transactional Replication of same SQL SERVER 2005

By poojak ·
Kindly suggest how can i perform Transactional Replication having Publisher, Distributor and subscriber all three in the same SQL server machine. I am using SQL server 2005 .
Can i use Transactional replication with updatable subscription.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Just set it up that way

by Tony Hopkinson In reply to Transactional Replication ...

Two databases on one server instance, or two instances with a database on each. All the examples are on different machines, because that's the way it should be set up, not the only way it can. It can be a complicated fellow to set up unless you are doing one for one, be prepared for a lot of head scratching. Presumably this is a test/development set up, if you start getting lost, hire a professional. If it's a live server, cease work immediately and hire a professional.

Related Discussions

Related Forums