Hi ALL,
So, in my project with SQL Server 2000, I need to replicate, when
insert/update data ina a sql server table, to another table, with same
structure, in Oracle.
I don´t know yet if I need to do that after any insert/update os sql table,
or in a interval of programmed hours.
Well, I never do that, and I don´t know what´s the best way, using DTS ou
using Linked Server.

Anyone can told me the best way, and the way to do that?

Thanks in advance ans sorry about my English!

Fernando

You could actually REPLICATE to Oracle

Q. How can I replicate data between SQL Server and IBM DB2, Oracle, and
other databases?
Microsoft SQL Server supports replication with heterogeneous data sources,
provided you have an ODBC driver or OLE DB provider for that data source.
Two types of replication are available today for heterogeneous database
replication: snapshot and transactional replication. With snapshot
replication, the database sends a point-in-time snapshot of the database to
or from SQL Server.

Transactional replication, on the other hand, is initiated with a snapshot,
and then maintains the consistency between the databases by sending database
modifications to the other database on a regular basis. Microsoft SQL Server
supports the distribution of database changes in SQL Server to other
databases. Third-party solutions are available for automating the
transactional replication from other databases to SQL Server.

The following are a few examples:

Replication with Oracle
Microsoft SQL Server enables snapshot replication to and from Oracle, as
well as Transactional replication from SQL Server to Oracle



If you would like to use DTS then you need a way of capturing the rows in
SQL Server that have changed between the times that the DataPump happens
from SQL Server to Oracle. You then simply use a SELECT statement with a
WHERE clause as the Source SQL Statement.




--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Fernando M. Lopes" <pergunte (AT) me (DOT) com> wrote

Hi,

StarQuest has some interesting products to replicate data from SQL
Server to Oracle: www.starquest.com

Bob

"Fernando M. Lopes" <pergunte (AT) me (DOT) com> wrote