Monday, March 12, 2012

Replication over the internet

Hi All,
Can I replicate from one sql server to another over the internet?
Regards,
Mekim
sure can. By default SQL Server communicates using port 1433. You will have
to deploy your snapshots using ftp.
If you are using MSDE subscribers the best way to deploy them is by using
anonymous subscriptions and use the activeX objects. Fill in values for
PublisherAddress, DistributorAddress, and PublisherNetwork and
DistributorNetwork.
"mekim" <mekim@.discussions.microsoft.com> wrote in message
news:4004177D-6C38-4F78-A812-3CFCB2F69C7A@.microsoft.com...
> Hi All,
> Can I replicate from one sql server to another over the internet?
> Regards,
> Mekim
|||THX!
"Hilary Cotter" wrote:

> sure can. By default SQL Server communicates using port 1433. You will have
> to deploy your snapshots using ftp.
> If you are using MSDE subscribers the best way to deploy them is by using
> anonymous subscriptions and use the activeX objects. Fill in values for
> PublisherAddress, DistributorAddress, and PublisherNetwork and
> DistributorNetwork.
> "mekim" <mekim@.discussions.microsoft.com> wrote in message
> news:4004177D-6C38-4F78-A812-3CFCB2F69C7A@.microsoft.com...
>
>
|||These links should help:
http://support.microsoft.com/?id=321822
http://www.microsoft.com/technet/tre...odtechnol/sql/
reskit/sql7res/part5/sqc07.asp
http://support.microsoft.com/default...32&Product=sql
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||THANK YOU!!!!
"Paul Ibison" wrote:

> These links should help:
> http://support.microsoft.com/?id=321822
> http://www.microsoft.com/technet/tre...odtechnol/sql/
> reskit/sql7res/part5/sqc07.asp
> http://support.microsoft.com/default...32&Product=sql
> HTH,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>

No comments:

Post a Comment