April 30, 2012 at 9:07 am
Hi Guys,
We have setup Transactional Replication from SQL Server 2008 R2 to Oracle 11 g in our all environments. We are only replicating on table. It was working fine before, suddenly last week i got emails from SV teams that data in SQL Server and Oracle is out of synch. What ever the changes are being made on SQL Server are not replicated to Oracle. We upgraded all SQL Server 2008 R2 to Service pack 1 to fix the replication bug in SQL Server RTM. Once we upgrade all SQL server 2008 R2 to SP1, we removed replication and then reconfigure the distributor and then establish the replication but still changes are not being replicated. Data in SQL Server and Oracle is out of synch but replication monitor does not show any error. It says status is OK.
Would you please help me with issue.
April 30, 2012 at 10:27 am
tajinder42 (4/30/2012)
We have setup Transactional Replication from SQL Server 2008 R2 to Oracle 11 g in our all environments. We are only replicating on table. It was working fine before, suddenly last week i got emails from SV teams that data in SQL Server and Oracle is out of synch. What ever the changes are being made on SQL Server are not replicated to Oracle. We upgraded all SQL Server 2008 R2 to Service pack 1 to fix the replication bug in SQL Server RTM. Once we upgrade all SQL server 2008 R2 to SP1, we removed replication and then reconfigure the distributor and then establish the replication but still changes are not being replicated. Data in SQL Server and Oracle is out of synch but replication monitor does not show any error. It says status is OK.
After all the changes... did you set a new snapshot?
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.April 30, 2012 at 11:05 am
Yes, We re-initialized the subscription. It created new snapshot and applied successfully on subscriber.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply