How can we achive a SQL server merge replication over the internet when both the client and server are Windows Xp machines and using SQL Server 7? Can someone please explain in a clear step by step fashion?
Is this a static IP or not.
Basically what you have to do it configure the publisher and subscriber using client network utilty, in the alias tab. Use the current TCP/IP address and a plain text server name (ie, don't use the ip address as the alias).
Then in your hosts file ( found in cd %windir%\system32\etc edit the hosts file to include both these servernames and the ip addresses. If the addresses are dynamic you will have to modify this each time you get a new ip address.
Then you have to configure an ftp server on your publisher and configure your merge publication for ftp.
Then create a pull subscription using ftp on your subscriber.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Rammy" wrote:
> How can we achive a SQL server merge replication over the internet when both the client and server are Windows Xp machines and using SQL Server 7? Can someone please explain in a clear step by step fashion?
>
|||One more thing. When you configure your subscriber, do not use the impersonate the SQL Server Agent on the publisher, use SQL Server authentication.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Hilary Cotter" wrote:
[vbcol=seagreen]
> Is this a static IP or not.
> Basically what you have to do it configure the publisher and subscriber using client network utilty, in the alias tab. Use the current TCP/IP address and a plain text server name (ie, don't use the ip address as the alias).
> Then in your hosts file ( found in cd %windir%\system32\etc edit the hosts file to include both these servernames and the ip addresses. If the addresses are dynamic you will have to modify this each time you get a new ip address.
> Then you have to configure an ftp server on your publisher and configure your merge publication for ftp.
> Then create a pull subscription using ftp on your subscriber.
> --
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
>
> "Rammy" wrote:
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment