Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  Sql Server to Oracle replication

Author  Topic  grv Starting Member 1 Post Posted - 2005-02-10 : 06:33:44 I am completely new to this. We are using Sql server at client side and Oracle as a central server. We wish to subscribe (Sql server) to subset of tables in central server (Oracle). I'll appreciate the ideas on how to start this project? One that I know is...... Using a data replication tool (http://sourceforge.net/projects/daffodilreplica), that can work with existing database servers over WAN set up. I can create publisher (specify the tables)on oracle and can subscribe sql server to it. But as I mentioned I am completely new to this. Your ideas and comments are welcomed. Please, suggest. thanx in advance. grv