I am setting up a database which needs to run in 6 different locations which are only connected by a very slow connection.
Without explaining the reasons why we have gone this way I am going to be running a replica database at each location and then want to set up SQL replication around the system.
Three SQL locations are SQL 2000 Server, 3 are SQL Developer Edition run on Windows 2000 clients.
What is the best way to have these 6 machines replicating to each other. Is there any rules about it and do the machines all have to be on the same domain, or can they be totally separate domains.
Your assistance is appreciated.
Without explaining the reasons why we have gone this way I am going to be running a replica database at each location and then want to set up SQL replication around the system.
Three SQL locations are SQL 2000 Server, 3 are SQL Developer Edition run on Windows 2000 clients.
What is the best way to have these 6 machines replicating to each other. Is there any rules about it and do the machines all have to be on the same domain, or can they be totally separate domains.
Your assistance is appreciated.
