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)
 Replication between MS SQL server and Oracle database

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-07-11 : 11:18:31
Philip writes "l have setup a replication between MS SQL Server 2005 Enterprise version and Oracle database.

I set up a distributor
I Set up an Oracle Publisher
I set up an Oracle Publication
I set up a Subcriber to the Publication (Articles are 15)

When l set the tables replicated, all the tables are created in MS SQL server, but only Five of them have data. Over eight hours now the rest have no data. What can l do to amke sure that the initial snapshot bring all data into all the tables?

Need help badly.

Philip"
   

- Advertisement -