March 4, 2013 at 8:39 am
Can I setup replications between two disconnected networks..??
For example..my company is a Web Application Development company and they sell their products through out the country to different clients.. Clients often use own web server to host their applications.. Some times they use their own.. This is the process. So our new requirement is replicating our database to a client in differnt location of the country... We cannot give access to the client to use our main database. But in order to do replication the subscriber should be able to connect to the publisher??? I am confused. Can I set up replication between two disconnected servers.???
--Pra:-):-)--------------------------------------------------------------------------------
March 4, 2013 at 8:50 am
...But in order to do replication the subscriber should be able to connect to the publisher??? I am confused. Can I set up replication between two disconnected servers.???
I am also confused! If your servers cannot talk (connect) to each other, how do you think the data can be sent from one to another? I'm not aware about any telepathic ability of SQL Server as yet. May be in SQL3012... 😉
Ok, your servers can be offline. But for replication to happen they will need ability to get online and connect to each other. Merge replication is the one which allows to achieve it.
March 4, 2013 at 8:53 am
It depends on how your replication is architected. I'm pretty certain the subscriber only needs to be able to talk to the distributor. Any "external" server needing replicated data will need to be able to talk to the distributor...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 4, 2013 at 9:05 am
Eugene Elutin (3/4/2013)
...But in order to do replication the subscriber should be able to connect to the publisher??? I am confused. Can I set up replication between two disconnected servers.???
I am also confused! If your servers cannot talk (connect) to each other, how do you think the data can be sent from one to another? I'm not aware about any telepathic ability of SQL Server as yet. May be in SQL3012... 😉
Thats a good one.. But Here is the idea...
How about sending the snapshot to an FTP server( our server location...may be by creating a shared folder in our network and pass the snapshots to that location???).. Is there any way that the subscriber without connecting to the main publisher server can be able to pull the data from snapshot folder in the FTP server location..
I remember for sure a subscriber can pull data from FTP server but my question is when is it not connected to a publisher network...
--Pra:-):-)--------------------------------------------------------------------------------
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply