On 2/9/07, Robertson-Ravo, Neil (RX) <[EMAIL PROTECTED]> wrote: > > Rick, wow, is this just for backup purposes? What an odd process for DB > replication!
No, our mainframe experiences several hours of downtime at night (like from 2-5am). It could run 24/7 but nobody in OIT wants to do that. Plus, there was a time when querying the mainframe database was difficult and unreliable due to connectivity issues that it took the mainframe guy several years of me harassing him before he bothered to spend time optimizing it for those type of connections (in the past, all of the work was done via 3270 or similar interfaces.. it didn't like the JDBC/ODBC connections at all) Replication wasn't an option because that would require purchasing very very expensive tools on the mainframe side. So we just got in the habit of exporting the data nightly and keeping a copy in our own "local" SQL Server database. Rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269285 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
