vraj20
asked on
Production Issue: Cannot Replicate data from SQL 2008 to SQL 2000
We are using Transactional Replication. I have data being pushed by multiple SQL 2000 Publication table into this one 2000 subscription table in SQL Server. Everything works fine. When I add the SQL 2008 Publication Table I get a lot of issues. I tried setting the synch to auto but the 2000 subscription would drop and be recreated which the other publication tables could not synch. I changed synch to replicate support only but the 2008 publication would throw out these types of errors The row was not found at the Subscriber when applying the replicated command.
vraj20, do you still need help with this question?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Thank you Victor
See Using Multiple Versions of SQL Server in a Replication Topology