Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Oracle replication between 2 MS SQL

Posted on 2009-04-21
Medium Priority
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 35

Accepted Solution

Mark Geerlings earned 2000 total points
ID: 24196061
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.

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Note: You must have administrative privileges in order to configure lead or case queues. Salesforce.com (http://www.Salesforce.com) is a cloud-based customer relationship management (CRM) system. It is widely used around the world by sales and ma…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Suggested Courses

571 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