RE: Archiving data into another database

From: Wittenmyer Joel - CO <WITTENMYERJ_at_tusc.com>
Date: Wed, 31 Jan 2007 14:31:00 -0600
Message-ID: <BB9C776D8D81DE4A9F217235582F6CF28FB2B3@TUSCMAIL.tusc.ad>

I've been watching this. I'll just offer a quick experience. I did this very thing for the Mayo Clinic a few years ago. We pulled everything from their Operational instance into an 'archive' instance using Oracle Streams. Because you can choose what actions on what tables to replicate and which not to, and because you can code your own enqueue and dequeue procedures it is extremely versatile. This was strictly for archival and reporting.

Joel Wittenmyer
Technical Management Consultant
TUSC - The Ultimate Software Consultants (303) 985-2213 (x116)

wittenmyerj_at_tusc.com <mailto:wittenmyerjr_at_tusc.com>

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jan 31 2007 - 14:31:00 CST