May 10, 2006 at 12:51 am
Hi guys
First, thanks to Mr. John who suggested me to start a new thread.
I am very new to this forum. Hope that my query will be answered. If I am not able to put up my query in clear manner please do reply to this post.
I want to setup a WAN for my SQL servers. I want to have a sQL Server at one Location with Static IP Address, and 2 more servers on different location. Each site will have it's own databases so that they can work independently. Those two servers data will be replicated to my central server whenever they require. I have a doubt in my mind wheter it is possible or not to access my central server which is having Static IP address through internet. And one more thing whether i will be able to administer those two servers from my central server. Here I want to use push subscription with remote agent activation. Please guide me. One thing will also be clear that that those two servers are not having any static IP and use to connect to internet either by Dial-Up or DSL.
I am thanking all of you in advance and please help me out.
Manoj
May 10, 2006 at 1:38 pm
I do know that you can do a replication over FTP, it is difficult in SQL Server 2000. Replication over HTTPS is advertised as a feature with SQL Server 2005. You may want to try Pull subscription from the DSL -connected servers in case this new HTTPS replication would allow it.
Read 2005 Books Online article
How to: Configure Web Synchronization for Merge Replication (Replication Transact-SQL Programming)
http://msdn2.microsoft.com/en-us/library/ms147927.aspx
Regards,Yelena Varsha
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply