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

Originators form group to boost Presto SQL query engine

The Presto engine arose as an alternative to Hive for big data queries. Now, the Presto Software Foundation has formed to promote...

5 best practices for managing real-time data integration

Real-time data integration isn't like traditional data integration -- "it's moving, it's dirty and it's temporal," cautions one ...

Web integration platform eases way to machine learning models

StoryFit data scientists employ machine learning algorithms to gauge film script scenarios' prospects. They use Import.io tools ...

SearchBusinessAnalytics

Upswing in cloud business intelligence spawns migration issues

More organizations are looking to run BI and analytics applications in the cloud. This handbook offers insights into moving ...

Avoid turbulence when shifting to data analytics in the cloud

When migrating BI and data analytics to the cloud, factor existing analytics processes, software evaluation, data protection and ...

Information Builders CEO on cloud-first approach, machine learning

Information Builders' new CEO, Frank Vella, said the company's focus on cloud and machine learning will help it solidify a firm ...

SearchSAP

SAP managed services weed out IT complexity at Ball Horticulture

Ball Horticultural outsourced its SAP Basis administration to Symmetry when the complexity of its SAP environment grew, but ...

Haribo can't bear SAP S/4HANA implementation

Haribo's recent deployment of S/4HANA may have led to problems getting its products into stores, but experts believe they could ...

10 record-to-report tips in SAP ECC for audit compliance

Ensuring a comprehensive segregation of duties and limiting the financial postings that can be made manually are some of the ways...

SearchSQLServer

SQL Server auditing best practices: 3 key questions for DBAs

Acing a SQL Server database audit starts with careful monitoring of how sensitive data is accessed and used so you can answer the...

Talend Stitch tools load data to Azure SQL Data Warehouse

Cloud data warehouses see serious data transformation work moving to the cloud. Talend's first integration with Stitch, which it ...

5 trends for SQL Server environments as SQL Server 2019 looms

SQL Server is undergoing new changes, as Microsoft prepares to release the 2019 version of the database software. Other changes ...

TheServerSide.com

Convert JPEG to SVG to improve webpage performance

Vector images open the door for multiple benefits on HTML webpages. Consider SVGs instead of raster images to boost HTML speed ...

Master-slave terminology alternatives you can use right now

Software companies have found alternatives for master-slave terminology to describe their distributed systems. It's time for the ...

RESTful parameters antipattern considerations for queries, paths

Choose carefully for path and query parameters in URL design. Lackluster choices in the design phase can plague client resource ...

SearchDataCenter

A data center planning and design guide for IT pros

Data center design and management now goes beyond servers and networking cables. Defining budget and IT goals helps set an ...

Data center budget process should review business goals first

Discover four factors data center managers should evaluate when allocating financial resources and areas to address to ensure ...

How to prepare your data center for an HCI appliance

Vendors tout hyper-converged infrastructure as a plug-and-play offering, but before you install anything in your data center, be ...

SearchContentManagement

How content services can speed up cloud content migration

During a continuous, or hot, migration, a content services platform can move content from the legacy repository to a new one -- a...

Personalized content solidifies the customer experience

Today's customers expect customized, curated digital experiences. Learn how to deliver what customers need and stay ahead of the ...

Create a winning personalized customer journey

Web content management platforms, customer data platforms and matchmaking can all help companies create and implement a ...

SearchHRSoftware

AI in recruiting may be above HR's head

Video job interviews are powerful tools. HireVue's AI algorithm can watch a candidate without losing focus and notice things a ...

Cybersecurity education: How HR can plan for the inevitable

Cybersecurity is a major concern for any organization, but employees continue to be a top threat. HR can help mitigate insider ...

LinkedIn's recruiting platform billed as 'Intelligent Hiring Experience'

LinkedIn's use of AI requires the sharing of data. It is one reason why the company is combining its talent tools into one system...

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.