29-10-2014, 09:29 AM
Abstracts: In the area of manageability, Oracle’s main competition has traditionally come from SQL Server. Both vendors have made enhanced manageability of their database server a primary objective, with new features being added with every new release to make database management easier and more cost-effective. Despite the addition of new features in the area of manageability in SQL Server 2008, it still lags behind Oracle Database 11g. Oracle Database 11g is a sophisticated self-managing database that automatically monitors, adapts, and fixes itself. The self-managing solutions found in the Oracle Database allow DBAs to be more productive, and helps their organizations reduce management costs without compromising service level objectives. So we migrate SQL server towards oracle.Oracle GoldenGate is a comprehensive software package for enabling the replication of data in heterogeneous data environments. The product set enables high availability solutions, real-time data integration, transactional change data capture, data replication, transformations, and verification between operational and analytical enterprise systems.