I have SQL Server 2000 as publisher and SQL Server 20008 R2 as subscriber.
I want to replicate data from SQL Server 2000 to SQL Server 2008 R2 on a different machine.
Primary key fields are not defined on some tables so transaction replication is not a choice.
I think merge replication is not a choice because the Subscriber SQL Server version is higher than the publisher.
What can I do?