Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Beginning Replication

0 views
Skip to first unread message

DJJ

unread,
Aug 23, 2008, 10:31:50 AM8/23/08
to
Hi

I am not very experienced in Sqlserver2k administration. I do mostly
scripting. I need to replicate/synchronize/update data between our company
server at our head office in Massachusetts running Sqlserver2K standard
edition with a desktop at our Manhattan sales office running Sqlserver2K
personal edition. I would like to be able to do this over the internet or
phone line (whichever is best). Both locations have DSL service.

I have no idea how to start this process and I was wondering where or how to
begin?

Rgds,
DJ

Paul Ibison

unread,
Aug 23, 2008, 12:48:30 PM8/23/08
to
Can you set up a VPN? If so then it'll be a lot easier and secure.
Rgds,
Paul Ibison (www.replicationanswers.com)


José Araujo

unread,
Aug 25, 2008, 10:13:24 AM8/25/08
to
Hello,

Ideally you are able to setup a VPN link between the two offices (you should
be able too).

Once you resolve the connectivity (ie: that you are able to ping in both
ways using private IPs), you should be able to setup replication, since you
are going to have a "loose" connectivity you should look at Merge
replication in the BOL.

Hope that helps... José.

"DJJ" <gemdjj...@writeme.com> wrote in message
news:ein67zSB...@TK2MSFTNGP04.phx.gbl...

0 new messages