by Hi Friends,
I have an interesting replication scenario.
There are 2 Servers both of them SQL 6.5 Servers.One has a live IP i.e.,
permanently connected to the net.
The Second Server does not have a live IP and it connects to the net using
Dial-Up Networking and gets a new IP every time it dials up and connects to
the net.
We are supposed to configue Replication between these two servers.
The Replication Scenario is as follows:
Suppose there are 20 tables in the database which has to be replicated 10
are modified at the fixed IP SQL Server and the remaining 10 at the SQL
Server which does not have a Fixed IP.The variable IP server
will dial-up at a given time and establish a connection to the net and get a
new IP every time it dials-up.
Replication should be configued in such a way that at that particular time
the modified tables from both the sides have to be replicated.
One of the facts is that both of these servers have to be Publishers and
Subribers to each other.The most important point to be considered is that
can the server with a fixed IP be configured to Publish data to a
Server which has a dynamic IP allocation.
Suggestions are welcomed .
Tkanks in advance
Sarosh A.Mukaddam.