Oracle replication between 2 MS SQL

Posted on 2009-04-21
Last Modified: 2013-11-16
I was wondering if it is posible to use Oracle replication between 2 MS SQL databases?
And if performance would be higher than SQL replication..(merge)
Question by:secuteamers
    1 Comment
    LVL 34

    Accepted Solution

    I certainly would not expect Oracle to be able to do replication between two MS SQL databases faster than native MS SQL processes could do it!  Yes, Oracle can connect to non-Oracle databases via ODBC but then how can Oracle know which data is new or changed?  I'm not an expect with MS SQL, but I would expect that MS SQL would have an efficient way to know or determine which data was changed recently that needs to be replicated.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.’s Console is a great tool to view activities, leads, contacts, accounts and opportunities all in one screen. It is particularly effective during call blocks and working numerous activities at a time in a quick, repetitive fashion (suc…
    Note: You must have administrative privileges in order to create/edit Sharing Rules. ( (SFDC) is a cloud-based customer relationship management (CRM) system. It is a database most commonly used by sales an…
    This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
    Via a live example, show how to take different types of Oracle backups using RMAN.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now