We are on SQL 2005 and use Idera SQL safe and replicate the data twice daily. Works well and compression is much better that what is provided in SQL 2005. I hear SQL 2008 has some enhancements and will be looking into it once we are done with the upgrade to ITSM 8
Regards, Saby ________________________________ From: Anantha Jeyaprakash <mrwebminis...@gmail.com> To: arslist@ARSLIST.ORG Sent: Tuesday, January 15, 2013 10:58 AM Subject: Re: Replicate ITSM Data for BMC Analytics ** We have been using Oracle Dataguard. It replicates real time data. On Tue, Jan 15, 2013 at 8:05 AM, Das, Anusha <anusha....@kbslp.com> wrote: We have built a dedicated database that has the replicated ITSM database. We perform transactional replication from ITSM database onto the Analytics database. Both our databases are SQL. > >Thanks, >Anusha > >Saving the world: one ITSM user at a time > > > >-----Original Message----- >From: Action Request System discussion list(ARSList) >[mailto:arslist@ARSLIST.ORG] On Behalf Of Maxence Nhouyvanisvong >Sent: Tuesday, January 15, 2013 4:23 AM >To: arslist@ARSLIST.ORG >Subject: Replicate ITSM Data for BMC Analytics > >Dear All, > >I would like to know if there is someone who has already built a solution that >replicates ITSM data to a dedicated database for BMC Analytics (BO). Some >technical options that could be used in our context are: Informatica IDR >(ETL), Oracle Dataguard and Oracle Golden Gate. Does anyone use one of that >technology and has some feedbacks from experiences (pros, cons, issues)? > >Thanks in advance, Maxence > >_______________________________________________________________________________ >UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers >Are, and have been for 20 years" > >_______________________________________________________________________________ >UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >"Where the Answers Are, and have been for 20 years" > -- Cheers, Ananth _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"