Ok..here is my problem. I have two SQL servers that I need to have
identical, at least semi-real time data on. One is in a public DMZ
with full access to and from the internet, and one is behind a
corporate firewall and the box can get out to the internet but cannot
be hit directly from the internet in. The two are on seperate
networks and cannot be connected via lan. Is there a way for me to
have semi-real time data transfers between the two to keep both
servers identical? I have thought that the server behind the firewall
could initiate an XML session with my dmz sql server and process
updates, but I am unfamiliar with how it would know what has changed
on the remote server and how the remote server would know what has
changed on the server behind the corporate firewall. Any good ideas?
Thanks
Dan Hirsch