"Integration databases—don't do it! Seriously! Not even with views." --M.T. Nygard #readingToday
Integration databases—don't do it! Seriously! Not even with views. Not even with stored procedures. Take it up a level, and wrap a web service around the database. Then make the web service redundant and accessed through a virtual IP. Build a test harness to verify what happens when the web service is down. That's an enterprise integration technology. Reaching into another system's database is just...icky.
"Release It!" -- Michael T. Nygard