----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: Gogi7735 Message 6 in Discussion Hi Vinod, Our requriment we have central database (oracle) where all the information regarding our application resides.we have a proposal to set up a different database (On SQL Server) as a central data repositray for reporting purpose(very Crucial as our business runs on reports ,for tracking purpose) ,data mining and to replicate data from other SQL Servers(our application Sub Systems database).To Replicate Data from SQL Server to SQL Server is simpler(Apply intital snap shot and set up Transactional replication).To Replicate data from Oracle to SQL in transaction mode is where i am looking for options.one way i have done is through Transperent Gate way +Triggers + Stored Procedures from oracle end.We can use DTS for batch update.but what we need is as soon as changes happens on the Oracle Database we need to replicate the data to SQL Server. Regards -Srini ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/BDOTNET/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
