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.
| Author |
Topic |
|
amalsql
Starting Member
1 Post |
 Posted - 2012-07-08 : 13:47:23
|
| Hello all,We have implemented transactional replication between Oracle and Sql.Oracle 11g as a publisher and Sql server 2005 as a subscriber.It worked for a month. We have replicated only 2 tables out of whole dadtabase. But as if now, the records i.e. row count is not syncronising. At oracle side, Logreader.exe is active and at Sql sevrer side there are no error logs as well. Everything is running fine, we restarted the agent as well, But not able to get an synchronized data. In SQL Server, it shows that commands are delivered every now and then. Confused about the issue. Its urgent as on Production. Please Suggest...Regards, Amal |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2012-07-08 : 16:28:38
|
| Did the subscription expire?You may need to re-snapshot |
 |
|
|
|
|
|
Replication Oracle-SQL Issue