Software

Ask something
Discussion Locked

Oracle to SqlServer replication ?

0 helpful
3 replies

by Member 24355076

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Is it possible to replicate an Oracle database to a SqlServer database ?

The Oracle database is on AIX, the SqlServer on NT at another site. We do not need real-time replication, replication at sheduled intervals (every few hours) will suffice.

3 replies

by mservino

There are plenty of tools on the market that will allow for this. One that I have used in the past is INFO-Pump. It a fairly robust tool that allows for data migration across all platforms. I have used it to link Sybase, DB2, Lotus notes all intoone integrated system. I know for a fact that it supports both Oracle and SqlServer. This product will allow you to mix and match data from multiple databases into one or many. It's a good solid tool. Here's a link if you want to look it up.
http://www.platinum.com/products/dataw/inpumps.htm#pi

I'm sure there are probably other tools out there as well, another that I know of is Replic-Action although this is more for Lotus Notes integration to other systems it does connect to SqlServer and Oracle and may also be of assistance to you.

good luck with whatever you choose.
-Mike

This discussion is closed to new replies.