Replicating transactional data from Oracle 9.2 RAC to SQL Server 7

I want to replicate data from Oracle 9.2 RAC on Linux to SQL Server 7.

I want to replicate data from Oracle 9.2 RAC on Linux to SQL Server 7. Could you help me as to what are the ways in which it is possible? I want to replicate transactional data.

To move data from Oracle to SQL Server, you'll need to use a product called Transparent Gateways. With Transparent Gateways, you set up a database link in your Oracle database to a non-Oracle database. The nice thing is that Oracle does not even need to know if the remote database is SQL Server, DB2, or anything else. Once you have that database link set up, you can write triggers to be fired when your tables change and push the data into SQL Server across the Transparent Gateway link.

There are 3rd party software solutions which can help as well. A quick search on Google should find them.

This was last published in October 2004

Dig Deeper on Oracle database backup and recovery

All
News
Get Started
Evaluate
Manage
Problem Solve

Solving common Oracle error codes guide

Related Q&A from Brian Peasland

Managing Oracle connections from third-party apps

Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading

Perfect the Oracle RMAN duplicate 10g command

One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading

Managing SQL parent table-child table relations

Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

Meet all of our Oracle Database / Applications experts

View all Oracle Database / Applications questions and answers

SearchDataManagement

Datawatch Swarm on path to combine data prep, analytics

Datawatch plans to add analytics and data visualization tools to its Swarm data preparation platform, starting with integration ...

Data companies vie to fill spots in AWS cloud data lineup

Third-party players looking to join Amazon Web Services' cloud data lineup tout hedges against cloud lock-in. The vendors must ...

FaunaDB distributed cloud database hunts transactional NoSQL

Startup Fauna has built a "relational NoSQL" database for distributed transaction processing. Data consistency and speedy builds ...

SearchBusinessAnalytics

Why data literacy skills still matter with augmented analytics

Democratizing data analytics gives everyone access to tools and information, but data literacy is still required for analyzing ...

The benefits and challenges of augmented data discovery tools

Augmented data discovery tools enable users to gain faster insights into data, via automated data prep and pattern discovery, but...

5 self-service BI best practices for larger organizations

Self-service analytics programs can streamline the BI process by allowing users access to data, but scaling out to thousands of ...

SearchSAP

SAP Enterprise Asset Management targets IIoT data

Manufacturers are using IIoT data they gather with the SAP Enterprise Asset Management platform to provide predictive maintenance...

Do SAP Cloud Platform integration services deliver?

SAP Cloud Platform is touted for its integration capabilities, but some think that while it's good for SAP-to-SAP, it may not be ...

SAP intelligent enterprise requires new skills from partners

SAP partners need to change their thinking if they're going to enable the 'intelligent enterprise.' That was the big message from...

SearchSQLServer

SQL Server 2019 improves Linux, container support

The SQL Server 2019 release includes new big data integration features, a collection of database engine enhancements and improved...

Faster R&D pace complicates SQL Server upgrades for users

Microsoft is updating SQL Server and Azure SQL Database more quickly than it did in the past -- and keeping up with the new ...

Microsoft data platform gets new cloud, on-prem features

Microsoft released a second preview of SQL Server 2019 and said users can now run applications in either on-premises SQL Server ...

TheServerSide.com

Recent open source flaw highlights danger of social engineering hacks

What happens when open source developers hand the keys of their project over to a new maintainer? It can expose applications to ...

Don't contribute to the high IT project failure rate

Enterprise software development is difficult, so it's no surprise to discover there is a high IT project failure rate. Here's how...

What is the preferred developer operating system?

Does the developer operating system play a part in the SDLC equation anymore? Well, it depends on what you're programming. Mobile...

SearchDataCenter

Security, staffing land atop IT's edge computing challenges

Edge computing is a new way for data center admins to process data closer to the source, but it comes with challenges around ...

Edge computing architecture helps IT support augmented reality

Augmented reality benefits greatly from reduced latency, which makes edge computing a perfect partner in the data center.

Streamline data center power usage tracking with DCIM

If you want a more in-depth picture of your data center's power consumption, explore DCIM options that provide server workload ...

SearchContentManagement

Acquia transforms from WCM to digital experience platform

Acquia's product roadmap is a metaphor for many WCM vendors, which must focus on digital experience to remain competitive in a ...

2019 trends in content management: Personalization, AI

AI, personalization, open services platforms and vendor wars, content management software industry observers say, will be the top...

Exploring the best ECM software for your company

Explore some of the top ECM platforms on the market to help make your decision-making process just a little bit easier.

SearchHRSoftware

Boomerang employees drive interest in offboarding tools

Boomerang employees, workers who leave a company and later return, are leading HR departments to seek out offboarding tools that ...

6 HR vendors make Glassdoor's Best Places to Work

HR tech vendors make tools designed to improve a company's employee experience. So, it makes sense that a handful should appear ...

Ideas to curb bad candidate experience, including a free tool

Your hiring efforts should monitor job applicant resentment, which happens when candidates feel spurned by a company's ...

Dig Deeper on Oracle database backup and recovery

Related Q&A from Brian Peasland

Have a question for an expert?

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.