Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 1 down vote favorite

I need to setup replication for a Client but their production database server doesn't seem to have the components installed to enable publishing.

Is it possible to setup what should be the subscriber as the publisher and pull changes from the master database? And is this going to cause problems?

share|improve this question

1 Answer

up vote 4 down vote accepted

No.

The publisher is local to the data being published and can't be remote.

MSDN overview

You can have a separate distributor of course

You'll have to consider database mirroring perhaps as an alternative or enable replication at the client

share|improve this answer
So of the two mirroring or replication at the client which would be better and if I setup the client as the publisher would that mean that the replication is two way? – eaglestorm Sep 27 '11 at 4:53
2  
@eaglestorm: mirroring is a DR setup, not replication. But it simpler to set up and abuse for your purposes maybe. If you want 2 way data flow then you need replication and will have to set it up at the client – gbn Sep 27 '11 at 5:37

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.