Archive

Archive for November, 2009

Replication Republishing

November 5th, 2009 No comments


I never really used replication before I joined my current company. We host client databases in our environment and we had a request to replicate a client’s database to them. Our infrastructure group did not want to allow us to replicate directly from production to the client site.

I did some testing and found that I could make a subscriber a publisher as well. After some testing, we installed a new database server on the otherside of the firewall and replicated to this server. From here, I then created another publication and pushed this out to the client.

To my surprise, I was reading about replication and found that it was actually a valid method of replication. I figured I was being a bit of a cowboy with this approach. While I’d rather go direct using VPN, this method is very stable for us

See this link for more details:
http://msdn.microsoft.com/en-us/library/ms152553.aspx