I want to enable one - way incremental replication between two SQL servers but there is a third server between the two. I want to use push replication as two computers won't be always connected.
There are two local 2000 servers and third 7.0 is on the web.
Client wants that main local server where main database is located and changes etc. are made should not be directly connected to server on the Web.
He says that he will take the backup of database from main server everyday and copy it to a second local server which will work as a publisher.
Will replication work if database on the publisher is replaced everyday? Or replication will have to be configured everyday and all the contents will again be replicated to server on the web.
Is there any other way to make this setup work without any complications.
The solution I think is to also enable replication between the two local servers but then again the main database server will be connected to the Internet indirectly.
To avoid that can I use the second local server just as a proxy server. If yes how to configure Main local sql server (which has the database) to use proxy server (Not MS Proxy Server) to connect to Internet for replication. I have read the MS Articles but they use MS Proxy Server.