Groups | Blog | Home
all groups > sql server replication > july 2007 >

sql server replication : Oracle to SQL 2005 Replication


Deon
7/3/2007 6:42:01 AM
Greetings,

I am looking for a tool that i can use to replicate oracle tables into Sql
2005 database. Or if i can pull the data out of oracle using a sql tool that
would be perfect. The database tables are only 2GB or so. Can someone share
some insight on whether this is feasible or not.

Thanks In Advance

Paul Ibison
7/3/2007 9:30:01 AM
Transactional replication for Oracle Publishers (v 8.0.5 upwards) is built on
the Microsoft SQL Server transactional replication publishing architecture
for SQL 2005.
Pls have a look in BOL for more details.
Cheers,
Deon
7/3/2007 9:56:03 AM
Thanks Paul.

What is BOL?

[quoted text, click to view]
Paul Ibison
7/3/2007 7:33:52 PM
It's "Books on line" - the help guide that comes with SQL Server. Fairly
comprehensive guide but no screenshots unfortunately. The Sujoy Paul book
also has a chapter on Oracle replication as far as I recall.
Cheers,
Paul Ibison

AddThis Social Bookmark Button