Question Locked

Transactional Replication of same SQL SERVER 2005

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

2 replies

by tony hopkinson

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.

This discussion is closed to new replies.