CODEWITHSUNDEEP
sqloracle-databasesql-server-2012
amateur
amateur

Reputation: 44663

integrate data between oracle and sql server

I have an oracle database that is very large in size.

I also have a sql server database. I want to integrate data from the oracle database to the sql server database and also the opposite way. This does not need to be real time but can work in the background possibly on defined intervals during the day.

What is the process for setting this up and how may it be achieved?

Upvotes: 1

Views: 768

Answers (3)

alexherm
alexherm

Reputation: 1362

Creating DB links is the best option for this. With DB links the databases can talk to each other directly. No need for additional software or programming, this is standard functionality in Oracle and SQL Server and is very reliable.

Upvotes: 0

Shane
Shane

Reputation: 2627

You should look into Microsoft SSIS: http://en.wikipedia.org/wiki/SQL_Server_Integration_Services

Upvotes: 2

Clavijo
Clavijo

Reputation: 64

One possibility is to use Oracle Golden Gate software. It does cost money but it supports real time data movement between many different database architectures, including the ones you specifically care about.

Upvotes: 0

Related Questions