Rajeev here from Bangalore. This is the present scenario with us. In some multiple sites (say Bangalore, Chennai, Pune, Delhi etc) separate MS SQL servers were deployed and running for some couple of Months. Each SQL server holds same data structure (software etc). Now they want to introduce a central Oracle server and want to update (synchronize) database from each of these distinct SQL servers periodically, say on each day by 6:00 pm, so that any pint of time in Oracle Central server previous day’s transaction can be found.
I don’t have much work experience with Oracle, but in MS SQL I know DTS to do this. But how to synchronies Oracle with each distinct MS SQL only for last modified/inserted data? What feature/function available in MS SQL or in Oracle to do this job smoothly? Please help me in this regard. Thanks in advance.