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

11 features to look for in data quality management tools

As the need for quality data has increased, so have the capabilities of data quality tools. Learn how collaboration, data lineage...

How data lineage tools boost data governance policies

Enterprises can bolster data governance efforts by tracking how and when changes are made to data. Expert David Loshin offers ...

MarkLogic Data Hub Service aims to ease cloud use of NoSQL DBMS

MarkLogic rolled out a cloud-service version of its NoSQL database management system, a move designed to make the technology more...

SearchBusinessAnalytics

3 ways to make machine learning in business more effective

Dun & Bradstreet analytics exec Nipa Basu offers three tips on how to integrate machine learning tools into business processes to...

Nationwide sees ups, downs with self-service Tableau tools

Tableau provides users at insurer Nationwide with a versatile, self-service analytics platform. But the IT team faces some ...

Looker 6 update adds analytics applications to BI tool

With Looker 6, users of the BI platform can now access packaged applications that are designed for uses such as web analytics and...

SearchSAP

Experts laud SAP Analytics Cloud but question market position

The platform may be solid for predictive analytics, financial planning and other tasks of business analysts. But why use it ...

3 users say SAP development tools save time

SAP developers share their experiences with two SAP development tools: Attunity's Gold Client data management application and ...

SAP S/4HANA real-time analytics best for tactical decisions

Experts say the built-in tool is fine for operational decisions when running S/4HANA business processes, but not for ...

SearchSQLServer

SQL Server 2019 preview brings Hadoop, Spark and AI into DBMS

A SQL Server 2019 preview brings Hadoop and Spark into the fold, positioning the database as an all-purpose data portal. Azure ...

4 strategies to beat the SQL Server 2008 support cutoff

The looming end of SQL Server 2008 extended support should spur database teams into action. Consider these four options to extend...

How Azure SQL DW Gen2 boosts cloud data warehouse's performance

The Gen2 version of Azure SQL Data Warehouse gives Microsoft's cloud data warehouse a shot in the arm on performance, making it ...

TheServerSide.com

How to become a good software architect in 13 steps

It's not easy to find your role in an IT enterprise setting. But if you can follow these 13 steps on how to become a software ...

When you compare Java build tools, Maven comes out on top

What is the best Java build tool on the market? Is it Gradle? Do people still use Ant? Here, we explore why Maven is still one of...

New CDNs bring edge JavaScript to the app performance world

With content distribution networks loaded with edge JavaScript, Cloudfare promises to improve application performance and ...

SearchDataCenter

A look at fundamental Linux sed commands

The Linux stream editor is a useful way to run scripts in the data center. With these command examples, you can start to build ...

Minimize downtime during a data center upgrade

End users don't want their productivity interrupted by IT maintenance. With the right technology, testing and planning, you can ...

Navigate data center management software selection

Software evaluation can be a lengthy process, especially with both open source and commercial options. Functionality and support ...

SearchContentManagement

New rules for WCM tools enhance the search experience

WCM used to mean platforms for webpages viewed on desktops. Today, it's morphing into digital experiences, and it taps AI as well...

AI-assisted image and video search is next content frontier

You can search text, but it's harder to catalog images and video. New tools are automating those processes at the enterprise ...

Box AI strategy looks to give users AI development tools

Box wants to be the hub of its enterprise users' software and AI content ecosystems with integrations and partnerships ranging ...

SearchHRSoftware

During offboarding, exit interview best practices can gather data

Exit interviews present a great opportunity for HR professionals to collect data on why departing employees started looking ...

At Workday Rising, skills ontology feature for customers unveiled

Workday is creating a universal skills ontology, a feature made available in its most recent platform version update. Users opt ...

At its Talent Connect, LinkedIn unveils ATS and broad strategy

LinkedIn has developed an ATS platform and acquired employee engagement vendor, Glint. Its likely goal: Become a full-service ...

Related Resources

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.