Oracle to SQL 2005 Replication

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
Deon
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,
Paul Ibison
|||Thanks Paul.
What is BOL?
"Paul Ibison" wrote:

> 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,
> Paul Ibison

Oracle Linked Server

Does anyone have any experience with Oracle linked servers? We are
considering using an Oracle linked server to pull data out of an Oracle
database into a SQL Server application but our understanding is that a
query's where clause issued from SQL server to Oracle is not resoved until
the entire contents of the Oracle table is brought back to SQL server. Should
Oracle linked servers be generally avoided from within a SQL Server OLTP
application?
No...not necessarily. In addition, you can use Openquery
with the linked server. You just need to write the query
using PL/SQL syntax and not T-SQL syntax. But an openquery
will pass the query string to Oracle and the string you
passed will be executed on the Oracle box and the results
returned to SQL Server. Sometimes referred to as a
pass-through query.
-Sue
On Mon, 28 Feb 2005 08:57:02 -0800, "Ray Kurpiel"
<RayKurpiel@.discussions.microsoft.com> wrote:

>Does anyone have any experience with Oracle linked servers? We are
>considering using an Oracle linked server to pull data out of an Oracle
>database into a SQL Server application but our understanding is that a
>query's where clause issued from SQL server to Oracle is not resoved until
>the entire contents of the Oracle table is brought back to SQL server. Should
>Oracle linked servers be generally avoided from within a SQL Server OLTP
>application?

Oracle Linked Server

Does anyone have any experience with Oracle linked servers? We are
considering using an Oracle linked server to pull data out of an Oracle
database into a SQL Server application but our understanding is that a
query's where clause issued from SQL server to Oracle is not resoved until
the entire contents of the Oracle table is brought back to SQL server. Shoul
d
Oracle linked servers be generally avoided from within a SQL Server OLTP
application?No...not necessarily. In addition, you can use Openquery
with the linked server. You just need to write the query
using PL/SQL syntax and not T-SQL syntax. But an openquery
will pass the query string to Oracle and the string you
passed will be executed on the Oracle box and the results
returned to SQL Server. Sometimes referred to as a
pass-through query.
-Sue
On Mon, 28 Feb 2005 08:57:02 -0800, "Ray Kurpiel"
<RayKurpiel@.discussions.microsoft.com> wrote:

>Does anyone have any experience with Oracle linked servers? We are
>considering using an Oracle linked server to pull data out of an Oracle
>database into a SQL Server application but our understanding is that a
>query's where clause issued from SQL server to Oracle is not resoved until
>the entire contents of the Oracle table is brought back to SQL server. Shou
ld
>Oracle linked servers be generally avoided from within a SQL Server OLTP
>application?

Oracle Linked Server

Does anyone have any experience with Oracle linked servers? We are
considering using an Oracle linked server to pull data out of an Oracle
database into a SQL Server application but our understanding is that a
query's where clause issued from SQL server to Oracle is not resoved until
the entire contents of the Oracle table is brought back to SQL server. Should
Oracle linked servers be generally avoided from within a SQL Server OLTP
application?No...not necessarily. In addition, you can use Openquery
with the linked server. You just need to write the query
using PL/SQL syntax and not T-SQL syntax. But an openquery
will pass the query string to Oracle and the string you
passed will be executed on the Oracle box and the results
returned to SQL Server. Sometimes referred to as a
pass-through query.
-Sue
On Mon, 28 Feb 2005 08:57:02 -0800, "Ray Kurpiel"
<RayKurpiel@.discussions.microsoft.com> wrote:
>Does anyone have any experience with Oracle linked servers? We are
>considering using an Oracle linked server to pull data out of an Oracle
>database into a SQL Server application but our understanding is that a
>query's where clause issued from SQL server to Oracle is not resoved until
>the entire contents of the Oracle table is brought back to SQL server. Should
>Oracle linked servers be generally avoided from within a SQL Server OLTP
>application?