I have a situation where due to existing network architecture, i have an inventory databases in separate remote locations and they are on isolated subnets that need to communicate to a central location.
As a 'solution' (and i say that loosely), the architecture i came up with is fairly simple in design, however is proving to be kind of a nightmare to implement. To get around the corporate firewall issues etc, i have a local WCF service (multi-threaded/async) that
will simply act as a proxy for the isolated DB and communicate to the central location, and is called by triggers on the appropriate tables etc.. Basically keeping the central DB synchronized with the remotes, via the WCF service..
I realize there are a number of ways to do this via replication, or DB-DB sync etc etc, however I have been informed that there is no way that the network/security guys are going to open any firewall ports to those SQL Servers.. The WILL however open a point-to-point
firewall rule for the WCF services..
ok, so I have all of that working..
the problem now arises, that when the remote local service is notified, I then make a call to our centralized IMS (inventory management system) with 'generic' data of what changed. IMS then makes whatever determination based on it's business rules,
one of them to potentially update that r
View Complete Post